Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula doesn't calculate correctly
Excel 2000
Why would this function work in one excel notebook and not another almost identical one. The reference cells are the same. =(H46-1000/1000*K19+J19 In the first notebook it sums K19 and J19 In the second notebook it just calls the J19 entry. I am terribly confused. It is messing up our new price list. Can anyone help? Thanks |
#2
|
|||
|
|||
Where is the closing parenthesis in the formula? What do you mean by "just
calls the J19 entry"? -- Regards, Fred Please reply to newsgroup, not e-mail "OhMarty" wrote in message ... Excel 2000 Why would this function work in one excel notebook and not another almost identical one. The reference cells are the same. =(H46-1000/1000*K19+J19 In the first notebook it sums K19 and J19 In the second notebook it just calls the J19 entry. I am terribly confused. It is messing up our new price list. Can anyone help? Thanks |
#3
|
|||
|
|||
OhMarty Wrote: Excel 2000 Why would this function work in one excel notebook and not another almost identical one. The reference cells are the same. =(H46-1000/1000*K19+J19 In the first notebook it sums K19 and J19 In the second notebook it just calls the J19 entry. I am terribly confused. It is messing up our new price list. Can anyone help? Thanks You are missing at least one parenthesis depending on how you want the formula to work. How do you want it to work anyway? I can think of the following ways the above formula can be reconstructed with each one giving out a different answer. Formula 1: =(H46-1000)/1000*K19+J19 Formula 2: =((H46-1000)/1000)*K19+J19 Formula 3: =((H46-1000)/1000)*(K19+J19) Maybe, if you can give the desired result from your formula, we can figure out a way where the missing parenthesis/parentheses will be placed. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=319941 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate a formula with a not-to-exceed answer? | Excel Discussion (Misc queries) | |||
When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
Formula displays does not calculate | Excel Discussion (Misc queries) | |||
What is the formula to calculate Age when I have Date of Birth? | Excel Worksheet Functions | |||
Using ROUND formula to calculate tax | Excel Worksheet Functions |