Previous Topic Next Topic

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

Answer 1 / 3
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.
0
justshill
Oct 11, 2011 at 08:41 PM
Thanks-I'm still not getting it. How can I send the table for you to view?
0
justshill
Oct 11, 2011 at 08:50 PM
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
0
justshill
Oct 12, 2011 at 06:33 PM
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.
0
Answer 2 / 3
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
0
Answer 3 / 3
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
0

Similar discussions

Percentage Work
Winndixie -
RayH -

6 responses
Percentage calculation
dany -
m.thenmozhi -

2 responses
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response
Excel Formula
bicky@7 -
bicky@7 -

6 responses