=IF(E2="y",IF(G2<=14,"y",IF(G2=15,"n","answer for G2 between 14 and 15
undefined")),IF(E2="n",IF(G2<=30,"y",IF(G2=31,"n" ,"answer for G2 between 30
and 31 undefined")),"answer for E2 neither y nor n undefined"))
or
=IF(OR(AND(E2="y",G2<=14),AND(E2="n",G2<=30)),"y", IF(OR(AND(E2="y",G2=15),AND(E2="n",G2=31)),"n"," answer
undefined"))
--
David Biddulph

Help with cell function wrote:
E G H
2 y 14 y

What is the formula if E2 = y and G2= 14 or less, I want H2 to = y
What is the formula if E2 = n and G2= 30 or less, I want H2 to = y
What is the formula if E2 = y and G2= 15 or more, I want H2 to = n
What is the formula if E2 = n and G2= 31 or more, I want H2 to = n