Pete:
$188.49 would round down to $187.95.
$188.50 would round up to $188.95.
Thanks

"Pete_UK" wrote:

When would you stop rounding down? In your example you said that
$188.00 should be rounded down to $187.95, but what about $188.01,
$188.10, $188.25 ??

Pete

On Nov 13, 8:51 pm, Derby wrote:
Hi everyone and thanks for any help you can give.
I am using Excel 2003 to set retail pricing for products in my store.
I have a column where I list my cost, then another column with a formula
that automatically computes my retail price based on the profit percentage I
designate.
I need a formula to also round the computed retail price to the nearest
xxx.95.
For instance, if the retail price formula produces an answer of $188.00, I
want it to round that to $187.95. Similarly, if the formula produces $188.70,
I want it to round it to $188.95.
I've looked at both FLOOR and CEILING but I can't seem to make them work for
what I'm trying to accomplish.
Any ideas?
Thanks again in advance.