Your formula did help Judith, I did add a couple more criteria below. Can you
help?

"JudithJubilee" wrote:

Hi,

Try this:

=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))


--
Hope this helps


"Help with cell function" wrote:

This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))