Trying Again (Burt)

  • Thread starter Thread starter Help with cell function
  • Start date Start date
H

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")), "")
 
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
 
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?
 
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")) ?
 
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"
 
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
 
Back
Top