evaluating between 2 numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lgarcia - 01 Apr 2004 03:59 GMT

hi, i need to evaluate 25 between 10 and 50,
if yes, then a, if not then b.

i know how to do that using the if conditions and have a lot of time
using this way, i was wondering i there is another way to evaluate the
number in intervarls?

Reply to this Message

Dave Hawley - 01 Apr 2004 06:55 GMT

Hi lgarcia

Not too clear on your question, but try

=IF(AND(A1>9,A1<50),"a","b")

Reply to this Message

lgarcia - 01 Apr 2004 21:53 GMT

thanks dave, it worked =)

Reply to this Message

Dave Hawley - 01 Apr 2004 06:55 GMT

Oops, make that

=IF(AND(A1>9,A1<49),"a","b")

Reply to this Message