@brownnick Perhaps this formula in A4:
=IF(A3="W",A1*A2,0)
This will only look if A3 contain "W". If it does, then multiply A1 by A2, otherwise return zero. You could nest another IF that explicitly checks if A3 contains "L" and then return zero. The question that remains then is what should be show when A3 doesn't contain either "W" or "L". I.e. when it's empty or contains something else.
