View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Minty Fresh Minty Fresh is offline
external usenet poster
 
Posts: 22
Default Trying Again (Burt)

This appears to meet your conditions:
=IF(ISBLANK(X11),IF(AND(H11="x",K11<=14),"Y",IF(AN D(H11="x",K11=15),"N")),IF(AND(X11="x",H11="x",K1 1=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


"Help with cell function" wrote:

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