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

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



=IF(E2="Y",IF(G2<=14,"Y","N"),IF(G2<=30,"Y","N"))

Assuming G2 will not be an empty/blank cell:

=IF(E2="y",IF(G2<=14,"y","n"),IF(E2="n",IF(G2<=30, "y","n"),""))

--
Biff
Microsoft Excel MVP


"Help with cell function"
wrote in message ...
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

=IF(AND(G2<"",E2<""),IF(E2="y",IF(G2<=14,"Y","N" ),IF(G2<=30,"Y","N")),"")

If this post helps click Yes
---------------
Jacob Skaria


"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

=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