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