=SUM with a percentage in the formula

[EdPoltera]

I want to calculate the following:

15 hotel rooms

31 days in the month

25% occupancy

= how many rooms actually sold?

[#2 · Accepted solution]

@EdPoltera 

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.

[#3]

Thanks very much. Great advice!