Forum Discussion
=SUM with a percentage in the formula
It's actually a Product (the result of multiplication) you're looking for, not a SUM. The formula appears in this screen grab at the top; it's a formula that's in cell C5. The actual value in cell C2, by the way, is .25, formatted as percentage.
I'll grant you that you could write the formula as =SUM(A2*B2*C2), but that's totally unnecessary and a bad habit to get into. Use SUM when you're adding, but not when doing other kinds of arithmetic such as multiplying or dividing.
It's actually a Product (the result of multiplication) you're looking for, not a SUM. The formula appears in this screen grab at the top; it's a formula that's in cell C5. The actual value in cell C2, by the way, is .25, formatted as percentage.
I'll grant you that you could write the formula as =SUM(A2*B2*C2), but that's totally unnecessary and a bad habit to get into. Use SUM when you're adding, but not when doing other kinds of arithmetic such as multiplying or dividing.
