LinkBack URL
About LinkBacks
=ROUND(A1/4, 0) * 4
=ROUND(A1/4, 0) * 4
If I do this
round(.51/4,0)*4, I do not get an answer. I was hoping to get .50
I was hoping to get to the nearest .25. ????
If the value was .10, I will use the ceiling function, because if I have a value over .10 then I want to go up to .25, but all other values above .25 should go to the nearest .25. I will use and if statement if the value is below .25 THEN USE the ceiling and if above then use the round or mround.
Try:
=ROUND(0.51/0.25,0)*0.25
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Sorry, Danielle, typing too fast. I meant =ROUND(A1 * 4, 0) / 4.
NBVC got the equivalent right -- the first time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks