What do these numbers mean in the rounding formula?

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

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top