Logical functions

Hi Janet,

Thank you for your question. You're right, Excel can be very particular in what it wants from us for the correct outcome. For your data, the following IF statement works for me:

=IF(C3="Lost",0,SUM(Q3:T3))

To test for text, use = and ""
It's not case sensitive but spelling and spaces matter.
Also, when you "nest" a second function inside IF, make sure you put the opening and closing brackets in the right places.
Note that "Won" is implied in the Value if False.

If cell C3 (Won, Lost) is empty, you might want to write a nested IF statement to tell you it’s empty, otherwise Excel will simply return the Value if False:

=IF(C3="Lost",0,IF(C3=”Won”,SUM(Q3:T3),”Empty”))

I hope this helps.

Kind regards
Marius Barnard
STL