ExcelBanter - formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula (https://www.excelbanter.com/excel-worksheet-functions/240059-formula.html)

Help with cell function[_2_]

formula

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

Glenn

formula

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"))

T. Valko

formula

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

Jacob Skaria

formula

=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

David Biddulph[_2_]

formula

=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

All times are GMT +1. The time now is 01:15 PM.