Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel ranges within a cell.
A2 is the numerical value < 13, or between 13 - 18, or 18. What formula do
I use? I tried =IF(A2<=13,"A",IF(A213<18,"B", IF(A218,"C"))). The only part of the formula that doesn't work is it middle portion - IF(A213<18,"B". Whataya think? Thanks so much. Danny |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel ranges within a cell.
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(a213,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(a213,"A",if(a218,"B","C")) wouldn't work nicely (even though the formula is syntactically correct). 99 is bigger than 13, so you'd see an A. Danny wrote: A2 is the numerical value < 13, or between 13 - 18, or 18. What formula do I use? I tried =IF(A2<=13,"A",IF(A213<18,"B", IF(A218,"C"))). The only part of the formula that doesn't work is it middle portion - IF(A213<18,"B". Whataya think? Thanks so much. Danny -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel ranges within a cell.
.. IF(A213<18
Try it like this: .. IF(AND(A213,A2<18) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Danny" wrote: A2 is the numerical value < 13, or between 13 - 18, or 18. What formula do I use? I tried =IF(A2<=13,"A",IF(A213<18,"B", IF(A218,"C"))). The only part of the formula that doesn't work is it middle portion - IF(A213<18,"B". Whataya think? Thanks so much. Danny |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel ranges within a cell.
Thank you Dave. Will giv it a try and let you know.
Danny "Dave Peterson" wrote: 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(a213,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(a213,"A",if(a218,"B","C")) wouldn't work nicely (even though the formula is syntactically correct). 99 is bigger than 13, so you'd see an A. Danny wrote: A2 is the numerical value < 13, or between 13 - 18, or 18. What formula do I use? I tried =IF(A2<=13,"A",IF(A213<18,"B", IF(A218,"C"))). The only part of the formula that doesn't work is it middle portion - IF(A213<18,"B". Whataya think? Thanks so much. Danny -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel ranges within a cell.
thanks Max. Will give it a try an dlet you know.
Danny "Max" wrote: .. IF(A213<18 Try it like this: .. IF(AND(A213,A2<18) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Danny" wrote: A2 is the numerical value < 13, or between 13 - 18, or 18. What formula do I use? I tried =IF(A2<=13,"A",IF(A213<18,"B", IF(A218,"C"))). The only part of the formula that doesn't work is it middle portion - IF(A213<18,"B". Whataya think? Thanks so much. Danny |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel ranges within a cell.
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 --- "Danny" wrote in message ... thanks Max. Will give it a try and let you know. Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VIEWING adjacent/nonadjacent cells or cell ranges in Excel 2007 | Excel Discussion (Misc queries) | |||
Cell Variables and Ranges | Excel Discussion (Misc queries) | |||
How can I password protect specific cell ranges in Excel? | Excel Discussion (Misc queries) | |||
Cell ranges | Excel Discussion (Misc queries) | |||
how do i add different cell ranges using a formula | Excel Worksheet Functions |