Assuming your number between 0 and 1

=IF(AND(A10.5,A1<1),1,0)
or
=(A10.5)+0



"fati" wrote:

I need a function in XLs that works as below
return 0 if 0<my number<0.5
return 1 if 0.5<my number<1