Conditional calculations
How can I write a conditional SUM formula to get these totals.
If A2 has some value then it should SUM the values as =SUM(A2*C2) if A2 has "0" then
it should calculate SUM as =SUM(B2*C2).
What is the code for this one, please.
|