Assuming nothing happens to 0

=MAX(0,ROUND(your_formula,1)-0.01)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Jack" wrote in message
...
I want to round a price that i have created by using a formula to .09, .19,
.29, ......99. Example - the price I created by using a formula is $5.64
and
I would like to round it to $5.59 or $5.69.