Assuming your price is in cell A1, put this in B1
=IF(RIGHT(TEXT(A1,"$0.00"),1)/100<=0.05,A1-RIGHT(TEXT(A1,"$0.00"),1)/100+0.0
5,A1-RIGHT(TEXT(A1,"$0.00"),1)/100+0.09)
All on one line, watch out for email word-wrap..........
Vaya con Dios,
Chuck, CABGx3
"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.
|