If between function...
 

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!


--
killertofu
------------------------------------------------------------------------
killertofu's Profile: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=572473

If between function...
 

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")

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

If between function...
 

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

If between function...
 

Thank you very much!


--
killertofu
------------------------------------------------------------------------
killertofu's Profile: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=572473