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

Put this in H14:

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

Hope this helps.

Pete


On Aug 18, 1:57*pm, Help with cell function <Help with cell
wrote:
if cell e 14 = y and cell g14 is less than 15, h14 should be y...how do i do
it? Thanks

Help with cell function wrote:
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?

Put this in H14

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

"Help with cell function" wrote:

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

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Help with cell function" wrote:

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

Help with cell function;456453 Wrote:
if cell e 14 = y and cell g14 is less than 15, h14 should be y...how do
i do
it? ThanksPut this forumula in H14
=IF(AND(E14=y,G14<15),E14,"False")
You didn't state what should be shown if the statement wasn't true but
just chage "False" to whatever you want.


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126337