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"

Help with cell function wrote:
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")), "")


.