jrenee
02-07-2005, 10:33 AM
It's the darndest thing and hopefully someone can come up with an answer for me. I'm looking at the following:
(B7*F12)/100
B7 = 5500.00
F12 = 41.67
The end result in Excel is 2291.67.
However, when I calculate on any other medium it comes up with 2291.85. The correct answer should be 2291.85.
Now, in Excel the formatting of the cells are set as "number" with 2 decimal places.
I'm trying to create a worksheet that performs instant calculations for our plans examiners and inspectors, so that minute difference can really make a difference.
Anyone offer any suggestions?
Thanks.
(B7*F12)/100
B7 = 5500.00
F12 = 41.67
The end result in Excel is 2291.67.
However, when I calculate on any other medium it comes up with 2291.85. The correct answer should be 2291.85.
Now, in Excel the formatting of the cells are set as "number" with 2 decimal places.
I'm trying to create a worksheet that performs instant calculations for our plans examiners and inspectors, so that minute difference can really make a difference.
Anyone offer any suggestions?
Thanks.