stop rounding

[Guest]

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.

 

[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.

 

[Guest]

Thank you! It worked!

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.