evaluating between 2 numbers

[lgarcia]

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?

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Dave Hawley]

Hi lgarcia

Not too clear on your question, but try

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

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Dave Hawley]

Oops, make that

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

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[lgarcia]

thanks dave, it worked =)

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****