If Statement

[andreascostas]

I have a decimal in cell a1 I need an If/and/or statement that can handle these conditions condidtions:
if A1 is between 0 and 0.2 then "close to zero", if A1 is between(0.4 and 0.6 then "close to half" and if it is greater than 0.79 then "close to one"
Thanks

 

[BadgerRoad]

What do you want to do if A1 is greater than .2 and less than .4 or greater than .6 and less than or equal to .79?

 

[andreascostas]

OK good question I think I will set up the decimals to fall within those parameters....

 

[BadgerRoad]

See if this does what you need:

=IF(A1>0,IF(A1<=0.2,"close to zero",IF(A1>=0.4,IF(A1<=0.6,"close to half",IF(A1>0.79,"close to one","something else")))))

 

[Scott Huish]

Your middle condition is missing, the between 0.2 and 0.4 range, but perhaps:

=LOOKUP(A1,{0,0.2,0.79},{"Close to Zero","Close to Half","Close to One"})

 

[BadgerRoad]

Are you sure my middle condition is missing? He doesn't have any condition between .2 and .4 the way I read it.

 

[Scott Huish]

The op said:

OK good question I think I will set up the decimals to fall within those parameters....

 

[BadgerRoad]

I wasn't sure and still am not sure which way he meant that. Anyway, I like your solution better if it does what he wants.

 

[andreascostas]

Thank you that worked....