Round number to nearest .05
I really hope someone has the answer to this. I need to round numbers up in a spreadsheet to the nearest .05. For example, I would need to change 1.50 to 1.55 or 1.57 to 1.65. I looked all throught the excel help menu and couldn't find anything.
Please help
Gail Wiley
With
A1: (a number)
This formula rounds that value UP to the next number ending in 0.05
(eg 0.05, 0.15, 0.25, etc)
Does that help?
Please Login or Register to view this content.
Yes
Yes, that did it. I knew it would be something simple that I just missed. Always is. That worked great.
Thank you so much for your help.
Hi, I saw this as a possible solution to what I was doing with rounding up to the next .05 HOWEVER, this doesn't quite work for me.
I am working with dollars and cents and need it to round up to the next nickel.
This formula does round to the next 05 but it skips the 00 as in .05, 10, 15, 20 it goes from .15 to .25 I need it to just go in .05 increments could you help please
what I am trying to say is
if I have 1.67 I want it to be 1.70 this formula rounds it to 1.75
it works for 1.63 to 1.65 or 1.61 to 1.65 but fails to round to any number ending in 0 10, 20, 30, 40 etc
Last edited by KTarley; 10-12-2013 at 04:55 PM. Reason: not sure I made myself clear
Try this version
=CEILING(A1,0.05)
Audere est facere
Excellent solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks