New Formula (Burt)

  • Thread starter Help with cell function
  • 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"))
 
J

JudithJubilee

Hi,

Try this:

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

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
 
H

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
 
J

Joe User

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


----- original message -----
 
H

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
 
H

Help with cell function

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

Help with cell function

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

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top