Formula doesn't calculate correctly

O

OhMarty

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
 
F

Fred Smith

Where is the closing parenthesis in the formula? What do you mean by "just
calls the J19 entry"?
 
B

BenjieLop

OhMarty said:
Excel 2000

Why would this function work in one excel notebook and not anothe
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. Ca
anyone
help? Thanks
Click to expand...

You are missing at least one parenthesis depending on how you want th
formula to work. How do you want it to work anyway?

I can think of the following ways the above formula can b
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 ca
figure out a way where the missing parenthesis/parentheses will b
placed
 
Top