Trying Again (Burt)
can I email anyone the spreadsheet to understand better
"Bob I" wrote:
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 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")), "")
.
|