use other cell information to put formula in current cell

[Help with cell function]

if cell e 14 = y and cell g14 is less than 15, h14 should be y...how do i do
it? Thanks

 

[Pete_UK]

Put this in H14:

=IF(AND(E14="Y",G14<15),"Y","")

Hope this helps.

Pete

 

[Glenn]

if cell e 14 = y and cell g14 is less than 15, h14 should be y...how do i do
it? Thanks

And if E14 <> "Y" or G14>=15, what should be in H14?

 

[Sam Wilson]

Put this in H14

=IF(AND(G14<15,E14="Y"),"Y","")

 

[Luke M]

What happens if criteria is not met?
Something like this in cell H14 is what you're looking for:

=IF(AND(E14="y",G14<15),"y","Criteria not met")

 

[Simon Lloyd]

if cell e 14 = y and cell g14 is less than 15, h14 should be y...how d
i d
it? ThanksPut this forumula in H1

=IF(AND(E14=y,G14<15),E14,"False"
You didn't state what should be shown if the statement wasn't true bu
just chage "False" to whatever you want

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com