Rounding Up to a specific number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
With
A1: (a currency amount)

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

Does that help?

Regards,

Ron
Microsoft MVP (Excel)
 
Holly SH%#! Don't know what I did, but it works. I will research it to
understand what I did.

Thanks a lot!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding up to nearest specified whole number 1
round up to nearest 50p 1
Round up to a specific figure 4
Round formula 1
Round-Up question 2
Formula Help 1
Average rounded to nearest 0.50 4
advice on rounding or ceilng a 24 hour time value 3

Back
Top