Excell Percentages Simple Stuff

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave Ratchford - 19 Dec 2003 10:21 GMT

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 !!??

Reply to this Message

Tushar Mehta - 19 Dec 2003 11:29 GMT

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%

Signature

Regards,

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

> 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:-
>
[quoted text clipped - 3 lines]
> I am sure it is a simple answer But i just cannot seem to see it.
> Can any one help a poor thicko !!??

Reply to this Message