Hello all ...
Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5
Is it possible to get the the following results:
0.1 - 0.25
0.15 - 0.25
0.2 - 0.25
0.22 - 0.25
0.4 - 0.5
0.6 - 0.5
0.7 - 0.75
0.9 - 1.0
1.2 - 1.00
1.4 - 1.5
Hello all ...
Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5
Is it possible to get the the following results:
0.1 - 0.25
0.15 - 0.25
0.2 - 0.25
0.22 - 0.25
0.4 - 0.5
0.6 - 0.5
0.7 - 0.75
0.9 - 1.0
1.2 - 1.00
1.4 - 1.5
Try:
=IF(A20>1,ROUND(A20*2,0)/2,ROUND(A20*4,0)/4)
Let me know if this works!
Steve
***If someone gave you good help, be sure to click the star at the bottom of their post!***
I don't see why .1 wouldn't be 0 (if .6 is to be .5) but this yields all the same results as your sample
=MAX(MROUND(A1,IF(A1>1,0.5,0.25)),0.25)
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks