If between function...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

killertofu - 17 Aug 2006 02:19 GMT

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!

Signature

killertofu

Reply to this Message

Franz Verga - 17 Aug 2006 02:32 GMT

> I am trying to figure out if there is a non-macro function that I can
> write for this scenario:
[quoted text clipped - 5 lines]
>
> Thanks peeps. All help is welcome!

Try this way:

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

Signature

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

Franz Verga - 17 Aug 2006 02:40 GMT

>> I am trying to figure out if there is a non-macro function that I can
>> write for this scenario:
[quoted text clipped - 9 lines]
>
> =IF(AND(A1>10,A1<=50),"YES","NO")

Also

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

Signature

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

killertofu - 18 Aug 2006 00:07 GMT

Thank you very much!

Signature

killertofu

Reply to this Message