Forum Discussion
Solved
=SUM with a percentage in the formula
I want to calculate the following:
15 hotel rooms
31 days in the month
25% occupancy
= how many rooms actually sold?
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.
- Thanks very much. Great advice!
