In article , "Ron Coderre" wrote:
With
A1: (a currency amount)

Try this:
B1: =CEILING(A1+0.01,1)-0.01

Does that help?

Regards,

Ron
Microsoft MVP (Excel)

"Phil" wrote in message
...
I want to round a price up to the nearest $.99. So if a number is $4.13 I
want it to round it up to $4.99, if its $10.53 Iwant to round it up to
$10.99. How do I do this?

Ah ... the obvious answer is 'get a marketing degree' :) That's one of their
favourite tricks ... trying to hide $5 as $4-99 and so on. :)