Trying Again (Burt)

[Help with cell function]

Sorry if this offends anyone, but I need an answer and I already submitted
this question yesterday.
the below formula was close, but not quite.
I only want a C to show up in L6 if a N is going to be the answer, if a Y is
the answer then I need to keep the Y. If X6 is not an x then the answer needs
to stay the same in L6

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

 

[Fred Smith]

You're not getting an answer because your question is not clear.

Explain what's wrong with the formula you are using, and what you want
instead. Provide some examples of what you are looking for.

Clear questions get answered very quickly in this forum. That's all you need
to do.

Regards,
Fred

 

[Sheeloo]

I would like to help but I am not sure what you want...
You need a formula in L6?

 

[Bob I]

you say
If X6 is not an x then the answer needs to stay the same in L6

The same as WHAT?

 

[Help with cell function]

Ok this is what I need.
In the L column I have a formula that gives me a yes (Y) or no (N) answer
depending on an answer to H and K columns. I've added another column X that
also plays into the equation now. The original formula in L11 is:

=IF(AND(H11="x",K11<=14),"Y",IF(AND(H11="x",K11>=15),"N"))

Now that I've added X11 into the equation I need a new formula. The one
below almosrt worked, but not quite.

=IF(H11="x", IF(K11<=14,"Y", IF(X11="x","C","N")), "")

In X11 I either put an x or no x. If I put an x in X11 I want a C to show up
in L11 if a N is going to be the answer, if a Y is the answer in L11 then I
need to keep the Y.

If X11 is blank then the answer needs to stay the same in L11

Did I make it any clearer or just more confusing?

 

[David Biddulph]

So isn't is as simple as changing your
=IF(AND(H11="x",K11<=14),"Y",IF(AND(H11="x",K11>=15),"N"))
to
=IF(AND(H11="x",K11<=14),"Y",IF(AND(H11="x",K11>=15),IF(X11="c","C","N")))
or
=IF(AND(H11="x",K11<=14),"Y",IF(AND(H11="x",K11>=15),IF(X11="c","C","N"),"whatever
you want when your second IF condition isn't satisfied")) ?

 

[Help with cell function]

can I email anyone the spreadsheet to understand better

 

[Bob I]

the formula is in L6, it will display Y, C, N or blank that is all that
has been defined, there is nothing else it can be the "same as"

 

[Minty Fresh]

This appears to meet your conditions
=IF(ISBLANK(X11),IF(AND(H11="x",K11<=14),"Y",IF(AND(H11="x",K11>=15),"N")),IF(AND(X11="x",H11="x",K11>=15),"C","Y"))

however, if h11 is blank or contains a value other than x, AND x11 is blank
it returns a FALSE
or
if h11 is blank or contains a value other than x, AND x11 is not blank, L11=Y

if you can give me some idea of what you want to do about non-x values in
h11 or x11, I can refine the formula