stop rounding

G

grianagh

In a worksheet, my formula is multiplying an expense times an income factor
of .00000 with the result being rounded to 0.00

When I total the column, my answer is a total of .00000 rounded to 0.00, not
a total of all the 0.00

It is making a difference of dollars to my expenses, and I need the real
expense!

Thanks for any help you can provide.
 
M

Myrna Larson

I think what you are describing is that the result of the multiplication is
DISPLAYED with only 2 decimal places, but in fact is not rounded to 2 decimal
places. Those formulas should be

=ROUND(A1*<expensefactor>,2)

Or at Tools/Options you can change the setting to Precision as Displayed.
 
G

grianagh

Thank you! It worked!

Myrna Larson said:
I think what you are describing is that the result of the multiplication is
DISPLAYED with only 2 decimal places, but in fact is not rounded to 2 decimal
places. Those formulas should be

=ROUND(A1*<expensefactor>,2)

Or at Tools/Options you can change the setting to Precision as Displayed.
Click to expand...
 
Top