How to combine "IF" functions

B

BeeCee

I have this function =IF(L9="w1",5,0) to test a cell for the text "w1" and
return value 10 if true, value 0 if false. This works as I want it to.

Now I want to test the same cell for text "w2" and return 10 if true. As a
stand-alone operation this would be =IF(L9="w2",10,0).

How can I combine these two functions in a single statement to test the cell
for either "w1" or "w2" returning either 5 or 10, and 0 if false?

Brian
 
H

Harlan Grove

BeeCee said:
How can I combine these two functions in a single statement to test the
cell for either "w1" or "w2" returning either 5 or 10, and 0 if false?
Click to expand...
....

Another alternative that arguably extends to more cases more easily than the
other responses others have given.

=SUMPRODUCT((L9={"w1";"w2"})*{5;10})
 

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

Similar Threads

If Function 1
How to get rows from 4 diff permitations?? 4
Need to test for alphanumeric value and write numeric values to ce 3
IF formula problem 3
Problem with advanced filter macro 8
How do I combine ISNA and IF functions 8
Nested IF Statement 3 Conditions, Need Help Fixing 7
Search for maximum set of values 5

Top