Calculating Profits

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

Guest

I need to know how to calculate profits.

If I but an item for "X" price and sell it for "Y" price my profit would be "Z" in money but what is the profit expressed as a percentage of "X"
 
Hi Derek,

Assuming,

A1=$100 (Sale Price)
A2=$80 (Cost)
A3=$20 (Gross Profit)

Gross Profit as a Percentage of Cost,

=A3/A2

and format as percentage

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Editorial Apple earning a massive profit per smartphone 11
GP Formula Needed 5
Formula for calculating price 1
How do I calculate profit as a % of Sales price 3
Profit sharing 8
How do I calculate profit per hour in excel? 1
need formula 4 %change on both neg and pos movemnt year to year co 4
Maintain the same number in a spreadsheet 2

Back
Top