I Need Help With Profit Percentage

Closed
Justshill - Oct 10, 2011 at 07:51 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 12, 2011 at 10:23 PM
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 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 10, 2011 at 09:50 PM
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.
Thanks-I'm still not getting it. How can I send the table for you to view?
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
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.
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 11, 2011 at 09:41 PM
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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 12, 2011 at 10:23 PM
post a small extract of your sheet