Jun 30 2022 09:00 AM
I want to calculate the following:
15 hotel rooms
31 days in the month
25% occupancy
= how many rooms actually sold?
Jun 30 2022 09:43 AM
Solution
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.
Jun 30 2022 09:43 AM
Solution
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.