If between function...

K

killertofu

I am trying to figure out if there is a non-macro function that I can
write for this scenario:

If A1 is greater than 10 and less than 50, return YES.

Here's what I had, but it always returns false:
=IF(A1>10 & A1<=50,"YES","NO")

Thanks peeps. All help is welcome!
 
F

Franz Verga

killertofu said:
I am trying to figure out if there is a non-macro function that I can
write for this scenario:

If A1 is greater than 10 and less than 50, return YES.

Here's what I had, but it always returns false:
=IF(A1>10 & A1<=50,"YES","NO")

Thanks peeps. All help is welcome!
Click to expand...


Try this way:

=IF(AND(A1>10,A1<=50),"YES","NO")

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
F

Franz Verga

Franz said:
Try this way:

=IF(AND(A1>10,A1<=50),"YES","NO")
Click to expand...


Also

=IF((A1>10)*(A1<=50),"YES","NO")

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top