Franz Verga wrote:
killertofu wrote:
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(A110 & A1<=50,"YES","NO")

Thanks peeps. All help is welcome!


Try this way:

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


Also

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

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy