Friday, January 20, 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 / Total Fees * 100



= 95/103.26 * 100 = 92%



your Total Green amount is extremely high
  • map of idaho
  • No comments:

    Post a Comment