=SUM with a percentage in the formula

New Contributor

I want to calculate the following:

15 hotel rooms

31 days in the month

25% occupancy

= how many rooms actually sold?


2 Replies
best response confirmed by Hans Vogelaar (MVP)



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!