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.

Somethong like this...

=MAX(0,ROUND(A1,0)-0.05)
--
HTH...

Jim Thomlinson


"Chris" wrote:


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

On Feb 11, 7:08*pm, Chris wrote:
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.