Rounding Up to a specific number
 

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.

Rounding Up to a specific number
 

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?

Thanks.

Rounding Up to a specific number
 

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

Thanks a lot!

Phil

"Phil" wrote:

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.

Rounding Up to a specific number
 

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