Excel ranges within a cell.

[Danny]

A2 is the numerical value < 13, or between 13 - 18, or > 18. What formula do
I use? I tried =IF(A2<=13,"A",IF(A2>13<18,"B", IF(A2>18,"C"))). The only part
of the formula that doesn't work is it middle portion - IF(A2>13<18,"B".
Whataya think? Thanks so much.
Danny

 

[Dave Peterson]

If A2 is numeric, you could use something like this:
=if(a2<=13,"A",if(a2<18,"B","C"))

I guessed that you wanted C if A2=18.

But just for learning the =and() function:
=if(a2<=13,"A",if(and(a2>13,a2<18),"B","C"))

But if excel has already determined that A2 is not less than or equal to 13 (the
first portion of your comparisons), then you don't have to check again.

But you do have to do the comparisons in a nice order:

=if(a2>13,"A",if(a2>18,"B","C"))

wouldn't work nicely (even though the formula is syntactically correct). 99 is
bigger than 13, so you'd see an A.

 

[Max]

.. IF(A2>13<18
Try it like this: .. IF(AND(A2>13,A2<18)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Danny]

Thank you Dave. Will giv it a try and let you know.
Danny

 

[Danny]

thanks Max. Will give it a try an dlet you know.
Danny

 

[Max]

Welcome, my response was to let you get the hang of using AND
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik