Additional formula

[Help with cell function]

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

 

[cm]

try this:

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

 

[Francis]

Does your 2nd formula solved what you want?
if not, do you actually want to replace the N to a C?
if yes, then change the N in your formual to C
--
Hope this help

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

 

[Joe User]

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. [....]
=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6>=15),"N")))

=IF(H6="x", IF(K6<=14,"Y", IF(X6="x","C","N")), "")

Note that I simplified your original formulation. It is not necessary to
test if K6>=15 because that is implied by the fact that K6<=14 is false.

I also added a return value (the null string, "") so that the formula
returns something other than FALSE when none of the conditions is met.


----- original message -----