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