Calculation Problem

[jrenee]

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.

[mvidas]

Hi jrenee,

It seems like your F12 is not actually the value of 41.67, but instead is a calculation in itself (probably equal to the value 41.6667272727273)

You can get your desired result by rounding F12 in the function, like:


=(B7*ROUND(F12,2))/100

Matt

[jrenee]

You are the master. It worked like a charm, and I appreciate you solving this problem for me!

Thank you!!!!!

[mvidas]

No problem, glad to help!
Just so you know, you can mark your questions solved by going to Thread Tools at the top of the page, then Mark Solved. This cleans up the forum, and alerts other users that you're all set.
Let me know if you need anything else!
Matt