This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))

Hi,

Try this:

=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))


--
Hope this helps


"Help with cell function" wrote:

This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))

Try this:

=IF(X6="x","C",IF(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))

However, you are not catering for when H6 does not equal "x".

Hope this helps.

Pete

On Dec 22, 1:16*pm, Help with cell function
wrote:
This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))

That worked Judith. How about this, I only want this to work if an N shows up
in L6 not a Y. Thanks

"JudithJubilee" wrote:

Hi,

Try this:

=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))


--
Hope this helps


"Help with cell function" wrote:

This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))

See response to your other thread ("Additional formula"). Please do not post
multiple messages for the same question.


----- original message -----

"Help with cell function" wrote:

That worked Judith. How about this, I only want this to work if an N shows up
in L6 not a Y. Thanks

"JudithJubilee" wrote:

Hi,

Try this:

=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))


--
Hope this helps


"Help with cell function" wrote:

This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))

I'm not sure what "catering" is, but this is close. If there is no x in X6
then everything stays the same in L6. Any time there is a Y in L6 that needs
to remain. When L6 is an N and X6 is an X is the only time L6 needs to change
to C



"Pete_UK" wrote:

Try this:

=IF(X6="x","C",IF(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))

However, you are not catering for when H6 does not equal "x".

Hope this helps.

Pete

On Dec 22, 1:16 pm, Help with cell function
wrote:
This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))

.

Sorry, fairly new to this.

"Joe User" wrote:

See response to your other thread ("Additional formula"). Please do not post
multiple messages for the same question.


----- original message -----

"Help with cell function" wrote:

That worked Judith. How about this, I only want this to work if an N shows up
in L6 not a Y. Thanks

"JudithJubilee" wrote:

Hi,

Try this:

=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))


--
Hope this helps


"Help with cell function" wrote:

This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))

Your formula did help Judith, I did add a couple more criteria below. Can you
help?

"JudithJubilee" wrote:

Hi,

Try this:

=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))


--
Hope this helps


"Help with cell function" wrote:

This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))

I repeat: see responses (mine, in particular) in your other thread, and stop
wasting people's time pursuing incorrect responses in this thread.

PS: By "catering to", Pete apparently meant "paying attention to". I
handle that in my response in the other thread (klunk!).


----- original message -----

"Help with cell function" wrote:

I'm not sure what "catering" is, but this is close. If there is no x in X6
then everything stays the same in L6. Any time there is a Y in L6 that needs
to remain. When L6 is an N and X6 is an X is the only time L6 needs to change
to C



"Pete_UK" wrote:

Try this:

=IF(X6="x","C",IF(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))

However, you are not catering for when H6 does not equal "x".

Hope this helps.

Pete

On Dec 22, 1:16 pm, Help with cell function
wrote:
This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))

.

I repeat: see responses (mine, in particular) in your other thread, and stop
wasting people's time pursuing incorrect responses in this thread.

Being "fairly new" to posting here is no excuse for not using common of sense.


----- original message -----

"Help with cell function" wrote:

Your formula did help Judith, I did add a couple more criteria below. Can you
help?

"JudithJubilee" wrote:

Hi,

Try this:

=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))


--
Hope this helps


"Help with cell function" wrote:

This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))