New Formula (Burt)

  • Thread starter Thread starter Help with cell function
  • Start date Start date
H

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

Try this:

=IF(x6="x","C",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
 
That worked Judith. How about this, I only want this to work if an N shows up
in L6 not a Y. Thanks
 
See response to your other thread ("Additional formula"). Please do not post
multiple messages for the same question.


----- original message -----
 
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
 
Sorry, fairly new to this.

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


----- original message -----
Click to expand...
 
Your formula did help Judith, I did add a couple more criteria below. Can you
help?
 
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 -----
 
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 -----
 
Back
Top