"rikg" wrote in message
...
In making price lists, I want my prices to round to the nearest .x5 or .x9
..
The cells containing the prices are from a formula in another cell.
I'm not sure I understand what you want. I think 5.82 should be rounded to
5.8. If you want to round to the nearest 5 cent, use
=ROUND(A1*20,0)/20
/Fredrik
|