rounding a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=ROUND(your_formula,0)

--

Vasant

ricalyn said:
I did a formula where I multiplied currency with percentages, thus giving
Click to expand...
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!
 
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
-------------------------------------------

ricalyn said:
I did a formula where I multiplied currency with percentages, thus giving
Click to expand...
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!
 
Back
Top