if functions with positive and negative numbers

[Ronnie]

Could anyone help with this problem?

I want to use an if function to display some text if a
number falls between the range negative 1 to positive 1.

Thanks

Ronnie

 

[Andy B]

Hi

Try:
=IF(AND(A2>=-1,A2<=1),"Yes","No")

 

[Ron Rosenfeld]

Could anyone help with this problem?

I want to use an if function to display some text if a
number falls between the range negative 1 to positive 1.

Thanks

Ronnie

=IF(ABS(A1<=1),"some text")


--ron

 

[Stephen Bye]

I think you meant
=IF(ABS(A1)<=1,"some text")

 

[Ron Rosenfeld]

I think you meant
=IF(ABS(A1)<=1,"some text")

Thank you for that correction.


--ron