View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Trying Again (Burt)

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


"Help with cell function"
wrote in message ...
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=1 5),"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?