how to use function ceiling??
CEILING() rounds a number to the nearest integer or to the nearest multiple
of significance. Refer help for a much detailed explanasion
CEILING(15.08,0.1) will result in 15.1
Here since your condition is to roundown if less than or equal to .09. Use
ROUNDDOWN and ROUNDUP functions
=IF(MOD(A1,1)<=0.09,ROUNDDOWN(A1,),ROUNDUP(A1,))
If this post helps click Yes
---------------
Jacob Skaria
"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
|