rounding a formula

[ricalyn]

I did a formula where I multiplied currency with percentages, thus giving me numbers past the 2 decimal places which in turn when added together gives me cents that I don't want. I want 0 cents as then end result, but I can't figure out how to round the formula. Help!

 

[Vasant Nanavati]

=ROUND(your_formula,0)

--

Vasant

I did a formula where I multiplied currency with percentages, thus giving

me numbers past the 2 decimal places which in turn when added together gives
me cents that I don't want. I want 0 cents as then end result, but I can't
figure out how to round the formula. Help!

 

[Earl Kiosterud]

ricalyn,

You can have the result appear rounded with formatting (Format - Cells -
Number tab - Number - two decimal places. Any summing or other math done on
such formatted cells get the true values - not the rounded ones. If you
want to do math on the rounded cells, you can use Tools - Options -
Calculation - Precision as displayed along with the formatting to two
decimal places. Or you can have your original formula reduce it to the
rounded value:

=ROUND( YourOriginalFormulaExpression, 2)

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I did a formula where I multiplied currency with percentages, thus giving

me numbers past the 2 decimal places which in turn when added together gives
me cents that I don't want. I want 0 cents as then end result, but I can't
figure out how to round the formula. Help!