I need a formula which will always round a figure up to the nearest 9.
For example, I have 121 which would need to be 129.
I am currently using this formula:
=ROUNDUP(A1,-1)-1
However, if my figure is a whole number e.g. 100 it is rounded down to 99. I would need it to be 109.
Thanks.
In B1, copied down:
=IF(A1="","",INT(MAX(5,(A1-5))/10)*10+9)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
This will do it
=INT(A1/10)*10+9
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Dohh!! Just realised mine doesn't work at all!!!
or
=CEILING(A1+1,10)-1
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Looks very sophisticated though!Originally Posted by Glenn Kennedy
If it hadn't been for your above statement I was gonna start calling you Professor :-)
You can save the flattery for later!!!
Try:
=ROUNDUP(A1-9,-1)+9
Thank you all for all the options!
Working great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks