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

the below formula fixed the above question, I only want a C to show up in L6
if a N is going to be the answer not a Y. Hope this is not too confusing.
Thanks, Burt
=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))