New Formula (Burt)

[Help with cell function]

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

 

[JudithJubilee]

Hi,

Try this:

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

 

[Pete_UK]

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

 

[Help with cell function]

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

 

[Joe User]

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


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

 

[Help with cell function]

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

 

[Help with cell function]

Sorry, fairly new to this.

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


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

 

[Help with cell function]

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

 

[Joe User]

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 -----

 

[Joe User]

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 -----