if then statement... can't make it work:S

[sed]

i need some help trying to write a formula that states the following:
if a1 is greater than -5.01 and less than 5.01 then 1, 0
Thank you

 

[John C]

=IF(ABS(A1)<5.01,1,0)
or
=ABS(A1)<5.01

Hope this helps.

 

[Don Guillett]

Look in the help index for AND

 

[Mike H]

Try

=IF(AND(A1>-5.01,A1<5.01),1,0)

Mike

 

[sed]

Thanks again John!
--
sss

=IF(ABS(A1)<5.01,1,0)
or
=ABS(A1)<5.01

Hope this helps.

 

[muddan madhu]

=IF(A1>=5.01,1,0)

 

[John C]

Thanks for the feedback, and don't forget to check the little YES box below