Rounding Up to a specific number

P

Phil

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?

Thanks.
 
R

Ron Coderre

With
A1: (a currency amount)

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

Does that help?

Regards,

Ron
Microsoft MVP (Excel)
 
P

Phil

Holly SH%#! Don't know what I did, but it works. I will research it to
understand what I did.

Thanks a lot!

Phil
 
B

Bruce Sinclair

With
A1: (a currency amount)

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

Does that help?

Regards,

Ron
Microsoft MVP (Excel)
Click to expand...

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. :)
 
Top