Thursday, February 2, 2012

Excel formula - calculate the percentage of the total fees that comes from greens fees?

I'm having troubles understanding how to get this formula to recieve the correct answer of 92%



Question- In cell I6, calculate the percentage of the total fees that comes from greens fees (that is, divide the greens fees amount by the total amount).



Green fees - (D6) - 95

Total Green amount - (H6) - 25,555Excel formula - calculate the percentage of the total fees that comes from greens fees?
Green fees =Fees - 95

Players = Total green fees (25555.00) divided by 95 equals 269

92% of revenue is from green fees therefore 8% are other fees

Multiply 95 by 1.08 (8%) =102.60 (other fees are 7.60)

Total green fees is Total fees minus 25555.00 equals 102.60 multiplied by 269 players equals 27599.40

No comments:

Post a Comment