Formula Help

Formula Help

I am trying to see if i can convert my wonderful and extremely complicated spread sheet from excel 2003 to zoho.

Anyways here is the formula that I have that works in excel 2003, but not in zoho

      
  1. =IF(AND(H16="Male",H16="male"),"8",IF(AND(H16="M",H16="m"),"8",IF(AND(H16="Nursing",H16="nursing"),"12",IF(AND(H16="N",H16="n"),"12",IF(AND(H16="Female",H16="female"),"2",IF(AND(H16="F",I3="f"),"2",IF(AND(H16="Woman",H16="woman"),"2","enter male or female")))))))