How to combine "IF" functions
"BeeCee" wrote...
....
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?
....
Another alternative that arguably extends to more cases more easily than the
other responses others have given.
=SUMPRODUCT((L9={"w1";"w2"})*{5;10})
|