If between function...

[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!

 

[Franz Verga]

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!

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

 

[Franz Verga]

Try this way:

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

Also

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

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[killertofu]

Thank you very much!

 

[killertofu]

Thank you very much!