One way, try:

=IF(H200="","",VLOOKUP(H200,{0,"under 14";14,"under 16";16,"under
18";18,"under 20";20,"open";40,"40+";50,"vet"},2))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ditchy" wrote in message
oups.com...
Hello, can someone give me some help with this please
H200 is age
I need to add a new age group which is 40+
I have tried to add this to the formula but have trouble getting it to
work =if(H20040,H200<50,"40+"

=IF(H200=50,"vet",IF(H200=20,"open",IF(H200=18, "under
20",IF(H200=16,"under 18",IF(H200=14,"under 16",IF(H200<14,"under
14","false"))))))

all help much appreciated
regards
Ditchy