I Need Help With Profit Percentage
[Closed]
Report
Justshill

venkat1926
venkat1926
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
Related:
 I Need Help With Profit Percentage
 Percentage to paisa calculator  Forum  Office Software
 Excel check if cell is percentage ✓  Forum  Excel
 How to calculate monthly attendance percentage in excel  Forum  Excel
 PHP  Replace the percentage symbol  HowTo  PHP
 Excel  Figuring a number based on a percentage increase  HowTo  Excel
3 replies
venkat1926
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
suppose A2 is cost,B2 is sales C2 is profit
in C2 type the formla
=B2/A21
copy C2 down and format C column as percentage with two decimal places.
in C2 type the formla
=B2/A21
copy C2 down and format C column as percentage with two decimal places.
venkat1926
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
in excel the result of formula comes as fraction. you can just format is as percentage.
absolute profit=salescost
fraction profit=(salescost)/cost
percentage prfoit =((salescost)/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
absolute profit=salescost
fraction profit=(salescost)/cost
percentage prfoit =((salescost)/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
Tks
Profit
280.00
64.80
371.25
169.10
204.00
21.00
28.80
180.00
11.00