1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Typing formula in excel

  1. Jun 1, 2009 #1
    1. The problem statement, all variables and given/known data

    I have the formula
    S=t^(-1/b)*g
    I want to type this into excel.

    2. Relevant equations



    3. The attempt at a solution
    For S are values typed into the second column (B)
    for t are values typed into column A.
    I 'named' the b and g using the name manager and set the initial values as 1.
    then in the column C i want the predicted values for S so to get the first predicted value, i typed:
    =g*(A2^(-1/b))

    but i kept getting the #VALUE error and i dont know whats wrong with =g*(A2^(-1/b))
    Thank you
     
  2. jcsd
  3. Jun 1, 2009 #2

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    That #VALUE can happen when one of the "numbers" is actually text.

    A few things to look at are:

    What is the value in cell A2?

    And, what is the result when you type these formulas:

    =g

    =b​
     
  4. Jun 1, 2009 #3

    MATLABdude

    User Avatar
    Science Advisor

    It can also happen when the cell isn't wide enough to display the resultant value.
     
  5. Jun 1, 2009 #4

    sylas

    User Avatar
    Science Advisor

    That gives #####, not #VALUE.
     
  6. Jun 1, 2009 #5

    MATLABdude

    User Avatar
    Science Advisor

    Ah, correct you are. However, I was unaware that you could assign values like that in Excel. Whenever I've done that, it's been hardcoded values, or using a locked reference like $A$5 for a value in cell A5 which you don't want automatically incremented by Excel.

    EDIT: I think that might be why the OP's thing isn't working: they're trying to assign a value to b somewhere along the line, and then using the letter b in their calculations.
     
  7. Jun 1, 2009 #6

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    But doing that IS possible in Excel, it just has to be done properly.

    Check out Insert-Name-Define for how to assign a cell's value to a variable name.
     
  8. Jun 2, 2009 #7
    The value in A" (first value in that column) is 138.
    I used the 'name manager' to define g and b.
    I defined them then in A10 i put b and in B10 i put 1
    then in A11 i put g and in B11 i put 1
    (I put 1 because i needed to initialize the b and g) is this wrong?
    I used the idea from the website:
    http://www.csupomona.edu/~seskandari/documents/Curve_Fitting_William_Lee.pdf [Broken]
    see pages 6 and 7.
    then i typed =g*(A2^(-1/b)) and this gave a #VALUE error.
    But i dont know why?
     
    Last edited by a moderator: May 4, 2017
  9. Jun 2, 2009 #8

    sylas

    User Avatar
    Science Advisor

    Well, you are not getting #NAME? errors, so you must have defined g and b to be something.

    Make sure g and b are defined to be absolute references (with dollar signs) in the name manager. That's the default. Somehow you are using things that are not numbers.

    Here's what I think you are trying to do:
    excel.JPG

    Cheers -- sylas
     
    Last edited by a moderator: May 4, 2017
  10. Jun 2, 2009 #9
    ok, thanks.
    On the excel vista where's the 'solver' tool? i cant seem to find it since it's different to the windows xp.
    thanks
     
  11. Jun 2, 2009 #10

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    Have you installed the Solver add-in? Just having Excel does not necessarily mean you have Solver.

    Click on Tools, then Add-Ins. Is the box checked for "Solver"?
     
  12. Jun 2, 2009 #11
    but on my excel, there isnt a 'tools' section. there's just:
    home, insert, page layout, formulas, data, review, view.
    where can i find the add-ins?
    thank you
     
  13. Jun 2, 2009 #12

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    I see. You have Excel 2007, and I have Excel 2003. Things are laid out a lot differently.

    Here are instructions for installing Solver:
    http://office.microsoft.com/en-us/excel/HP100215701033.aspx [Broken]

    If you get to the part where the Solver box is already checked, that means you already should have it.
     
    Last edited by a moderator: May 4, 2017
  14. Jun 2, 2009 #13

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

  15. Jun 2, 2009 #14
    Thank you.
    I installed it just now.
    (I didnt have it before)
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Typing formula in excel
  1. Excel question (Replies: 1)

  2. Excel Help (Replies: 3)

  3. Ploting graph in excel (Replies: 3)

Loading...