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

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

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