Excell Percentages Simple Stuff

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find a way of representing the percentage profit against sales, then averaging out the profit across a group of sales thus:-

Sales Value as in cell C3 = 59,819.81
Profit on Sales as in Cell H3 = 26,248.57
The result i seem to be able to get is 43.55% which in fact is the actual cost of the sales and not the profit.
I am sure it is a simple answer But i just cannot seem to see it.
Can any one help a poor thicko !!??
 
I'm not sure I understand your question. H3/C3 is 43.88%

The cost of the goods sold would be C3 - H3, i.e., Sales Price - Profit
or 33,600 and change.

The profit as a % of cost of goods sold would be H3/(C3-H3) or
approximately 26.2/33.6 or a little under 80%

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top