There is a difference between what is STORED (for example 0.4396) and what
is DISPLAYED (example 0.44)
You can EITHER
1) use Tools | Options , open Calculations tab and check Precision as
Displayed
(but be aware it will affect other workbook that you open)
OR
2) tailor the formula to 2 decimals as in =ROUND(A2,2)*
50*37.5*0.85*ROUND(B2,2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MLK" wrote in message
...
I am getting unexpected results from a simple multiplication formula.
Column
A contains rates, Column B contains billing discounts and Col C calculates
the billing $.

For example: Col A = 100, Col B = .44 and Column C calculation is: a2*(
50*37.5*0.85)*b2
Both Column B and C display only 2 decimals.

The answer that comes out is $70,492.79 but I'm expecting $70,125. It
appears to be calculating at 7 decimal places but should only be
calculating
at 2. When I enter the actuals numbers into a function (100*1593.75*.44)
the answers comes out right (70,125).

Am I missing something basic? I have done a ton of formulas but have not
come across this before.