Hi. This formula
rounds to the nearest 0.5. I would like to add a condition that if C4>ROUND(C4*2,0)/2 then
e.g if C4= 16.21, I would like E4= 16.5 (not 16 like the formula above)
but if C4=23.51, I would like E4= 24 (not 23.5 like the formula above)
Hope you understand what I'm trying to do!
Code:
ROUND(C4*2,0)/2
e.g if C4= 16.21, I would like E4= 16.5 (not 16 like the formula above)
but if C4=23.51, I would like E4= 24 (not 23.5 like the formula above)
Hope you understand what I'm trying to do!