Previous Topic Next Topic

I Need Help With Profit Percentage

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 -
Hello,



Within a series of columns there are Cost, Sales, and Profit. Within each column are 9 rows each with the information. What formula will get me the profit percentage?

Tks

3 replies

Answer 1 / 3
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 802
suppose A2 is cost,B2 is sales C2 is profit

in C2 type the formla

=B2/A2-1
copy C2 down and format C column as percentage with two decimal places.
Report

Thanks-I'm still not getting it. How can I send the table for you to view?
Report

I know that this is the profit column, but what is the formula for calculating the profit percentage?

Tks
Profit
280.00
64.80
371.25
169.10
204.00
21.00
28.80
180.00
11.00
Report

Thanks-I don't think I have explained it very well. I have the columns of cost, the columns of sales, and the column of profit. I am being asked to create a formula to now reference the percentage profit of sales. None of the proposed formulas have created the answer. I just get an error msg in the cell.
Answer 2 / 3
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 802
in excel the result of formula comes as fraction. you can just format is as percentage.

absolute profit=sales-cost
fraction profit=(sales-cost)/cost
percentage prfoit =((sales-cost)/cost)*100

that is what my forula gives your table gives only absolute profit and not the cost. Profit is always related to cost. you can refer some elementary arithmetic book
Answer 3 / 3
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 802
post a small extract of your sheet
Ask a question