H
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
it? Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
use other cell information to put formula in current cell
P
Pete_UK
Put this in H14:
=IF(AND(E14="Y",G14<15),"Y","")
Hope this helps.
Pete
=IF(AND(E14="Y",G14<15),"Y","")
Hope this helps.
Pete
G
Glenn
Help said: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?
S
Sam Wilson
Put this in H14
=IF(AND(G14<15,E14="Y"),"Y","")
=IF(AND(G14<15,E14="Y"),"Y","")
L
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")
Something like this in cell H14 is what you're looking for:
=IF(AND(E14="y",G14<15),"y","Criteria not met")
S
Simon Lloyd
=IF(AND(E14=y,G14<15),E14,"False"Help said: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
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