View Single Post
  #2   Report Post  
Fred Smith
 
Posts: n/a
Default

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