What do these numbers mean in the rounding formula?

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

In the formula below how would I change it to round down to the nearest .95
cents. For example, $127.49 would become $126.95?

=MAX(0,ROUND(my forumula to set a price,1)-0.01)

I guess I'm wondering what each number means in the rounding formula.
 
This part:

ROUND(my forumula to set a price,1)

is rounding to the nearest 1 decimal place (i.e. 10 cents if this
represents dollars), and by subtracting 0.01 the rounding is then
to .x9. In your case, you might like to try this:

=ROUND(your_formula_or_value,0)-0.05

which would convert $127.49 to $126.95, but would convert $127.51 to
$127.95.

If you would like both of these to be rounded down, then use:

=ROUNDDOWN(your_formula_or_value,0)-0.05

Hope this helps.

Pete
 
Back
Top