Try this:

=IF(AND(E14="y",G14<"",G14<=14),"y","")

--
Biff
Microsoft Excel MVP


"Help with cell function"
wrote in message ...
I need to know if I can get a formula for the following:

If cell E14 is "y" and G14 is less than or equal to 14 the H14 should be
"y"