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

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

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

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

Hope this helps.
--
John C


"sed" wrote:

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

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

Look in the help index for AND

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sed" wrote in message
...
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

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

Try

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

Mike

"sed" wrote:

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

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

Thanks again John!
--
sss


"John C" wrote:

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

Hope this helps.
--
John C


"sed" wrote:

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

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

=IF(A1=5.01,1,0)


On Oct 15, 5:52*pm, sed wrote:
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

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

Thanks for the feedback, and don't forget to check the little YES box below :)
--
John C


"sed" wrote:

Thanks again John!
--
sss


"John C" wrote:

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

Hope this helps.
--
John C


"sed" wrote:

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