ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I need an Excel template that will calculate Retail Gross Profit (https://www.excelbanter.com/excel-worksheet-functions/90569-i-need-excel-template-will-calculate-retail-gross-profit.html)

Anthony

I need an Excel template that will calculate Retail Gross Profit
 
Hey Group:

I need an Excel template that will calculate Retail Gross Profit in
percentages
when I enter my cost of goods and sale price of the product.

Can anybody help?

Thanks!

William Okumu

I need an Excel template that will calculate Retail Gross Profit
 

lets take this assumptions
y for Sales X for Cost of sales

Gross Profit will be Y-X
%wise will be (Y-x)/Y which you can formt by Press Ctrl+Shift+5(with %
Sign)


--
William Okumu
------------------------------------------------------------------------
William Okumu's Profile: http://www.excelforum.com/member.php...o&userid=33745
View this thread: http://www.excelforum.com/showthread...hreadid=545486



All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com