View Single Post
  #1   Report Post  
ditchy
 
Posts: n/a
Default if greater or lesser than

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