View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Help with cell function[_2_] Help with cell function[_2_] is offline
external usenet poster
 
Posts: 33
Default Trying Again (Burt)

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?