Rounding up to the nearest nickel

  • Thread starter Thread starter jhangas
  • Start date Start date
J

jhangas

Help! I have a massive pricing update I need to put together rather
quickly.
I'm using the Roundup function in excel and I need dollar values to be
rounded up to the nearest nickel. IE- $3.73 will become $3.75, 3.78
would become 3.80, etc.

I can not seem to figure this out. The closest I can get is making a
number round up to the nearest dime, but can not seem to get it to
round up to the nearest nickel.

Any help would be greatly appreciated. Thanks,
Jeff
 
if the value is in cell b2, in c2 you can use
=CEILING(B2,0.05)
 
You must log in or register to reply here.

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

Can a formula be set up to round to the nearest nickel? 2
Roundup to nearest $.0.05 Help 2
Need to increase price by % and rounding up and down 5
How can I Round up to the nearest .25 11
rounding help 6
round up to nearest 50p 1
rounding up to nearest specified whole number 1
Round time up to nearest :15 2

Back
Top