# Multiple TRUE,FALSE criteria

1. ## Multiple TRUE,FALSE criteria

I would like a formula for column "C" that will output one of the following four values:

1) = "100" when column "A" value is negative and column "B" value is "W"
2) = (value of column "A") when column "A" value is positive and column "B" value is "W"
3) = "-100" when column "A" value is positive and column "B" value is "L"
4) = (value of column "A") when column "A" value is negative and column "B" value is "L"

My spreadsheet looks like column "A" and "B", but I'd like the values in column "C" to appear automatically via formula.

A B C
-143 W [100]
111 W [111]
167 L [-100]
-125 L [-125]

2. ## Re: Multiple TRUE,FALSE criteria

Try this in Column C and copy down:

=IF(AND(A1<0,B1="W"),100,IF(AND(A1>0,B1="W"),A1,IF(AND(A1>0,B1="L"),-100,A1)))

3. ## Re: Multiple TRUE,FALSE criteria

=IF(A1<0,if(B1="W",100,if(B1="L",A1,"NA")),if(B1="W",A1,if(B1="L",-100,"NA")))

This formula is based on the Positive Value and Negative value .

Here I check A1 is whether Positive or Negative and then check value based on B1 is "W" or "L" and give the results based on it

______________________________________________________________________________________________________________________________________
Please click * to say thank you

“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison

4. ## Re: Multiple TRUE,FALSE criteria

Fantastic! Appreciate it.

There are currently 1 users browsing this thread. (0 members and 1 guests)