for your single test, try

=IF(AND(A139,A1<50),"40+","not")

or add it into your existing formula
=IF(H200=50,"vet",IF(H200=40,"40+",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")))))))



ditchy Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=392404