Nested IF question
 

Hi all

Can anyone help me with some syntax please?

I have a value in column T, an integer indicating age. In column U I need
to enter a string depending on the age band it falls into:

If less than 25, "band 1"
If between 25 and 49, "band 2"
If over 49, "band 3"

I figure this is a nested if but am beaten by band 2 (=25 AND <50).

Thanks in advance as ever!

Sue JB

Nested IF question
 

=IF(T1="","",VLOOKUP(T1,{0,"Band 1";25,"Band 2";50,"Band 3"},2))

or

=IF(T1<25,"Band 1",IF(AND(T1=25,T1<=49),"Band 2","Band 3"))


--

Regards,

Peo Sjoblom

"SueJB" wrote in message
...
Hi all

Can anyone help me with some syntax please?

I have a value in column T, an integer indicating age. In column U I need
to enter a string depending on the age band it falls into:

If less than 25, "band 1"
If between 25 and 49, "band 2"
If over 49, "band 3"

I figure this is a nested if but am beaten by band 2 (=25 AND <50).

Thanks in advance as ever!

Sue JB

Nested IF question
 

One way:
=IF(A1<25,"band 1",IF(AND(A124,A1<50),"band 2","band 3"))

Paul

"SueJB" wrote in message
...
Hi all

Can anyone help me with some syntax please?

I have a value in column T, an integer indicating age. In column U I need
to enter a string depending on the age band it falls into:

If less than 25, "band 1"
If between 25 and 49, "band 2"
If over 49, "band 3"

I figure this is a nested if but am beaten by band 2 (=25 AND <50).

Thanks in advance as ever!

Sue JB

Nested IF question
 

Thank you Paul and also to Peo - problem solved!

BTW can anyone recommend a good book that goes into depth on Excel functions?

Best wishes
Sue

"PCLIVE" wrote:

One way:
=IF(A1<25,"band 1",IF(AND(A124,A1<50),"band 2","band 3"))

Paul

"SueJB" wrote in message
...
Hi all

Can anyone help me with some syntax please?

I have a value in column T, an integer indicating age. In column U I need
to enter a string depending on the age band it falls into:

If less than 25, "band 1"
If between 25 and 49, "band 2"
If over 49, "band 3"

I figure this is a nested if but am beaten by band 2 (=25 AND <50).

Thanks in advance as ever!

Sue JB

Nested IF question
 

Don't know about books, the only book I ever bought was about VBA and it was
by John Walkenbach and it was very good, he has also written about formulas

http://www.j-walk.com/ss/books/xlbook24.htm

my guess it is very good as well

here's a free workbook called function dictionary you can download with
examples of all functions

http://www.rondebruin.nl/id.htm

it's by Peter Noneley and it can be downloaded from Ron's site (at the
bottom of the page)

--

Regards,

Peo Sjoblom




"SueJB" wrote in message
...
Thank you Paul and also to Peo - problem solved!

BTW can anyone recommend a good book that goes into depth on Excel
functions?

Best wishes
Sue

"PCLIVE" wrote:

One way:
=IF(A1<25,"band 1",IF(AND(A124,A1<50),"band 2","band 3"))

Paul

"SueJB" wrote in message
...
Hi all

Can anyone help me with some syntax please?

I have a value in column T, an integer indicating age. In column U I
need
to enter a string depending on the age band it falls into:

If less than 25, "band 1"
If between 25 and 49, "band 2"
If over 49, "band 3"

I figure this is a nested if but am beaten by band 2 (=25 AND <50).

Thanks in advance as ever!

Sue JB