it has to be as follows:

eg A1 = 0.5, A2=1.3, A3=0

So, If 0 but less than 1 I want to have 1 but If it is higher than 1 and
want to the number

So
For A1 I would have 1
For A2 I would have 1.3
For A3 I would have 0

Regards,
jose


"Stephen" wrote:

"Joe" wrote in message
...
HI, Which formula I need to write So when the cell in A1 is 0 but <1 then
give me 1; but if 1 then give me the number

thanks


What if A1<=0?
What if A1=1?

maybe this will do?
=MAX(A1,1)