how to use function ceiling??
=ROUND(A1+0.4,0)
"keys2000" wrote:
got a problem with function ceiling, my formula is =ceiling(A1,1)
A1 = 15
my result is = 15
but if i change my A1 to = 15.01
my result is = 16
but i want my result like this
if A1 = 15.01 -- 15.09, i want my result to be 15
but if my A1 = 15.1 and above, i want my result to be 16
|