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

try this:

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


--
hope to help,
cm


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

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

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





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

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

"Help with cell function" wrote:
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 -----

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

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