Profit percentage



0
How to calculate profit percentage in excel

3 Answer(s)


0

=(selectvalue1-selectvalue2)/ selectvalue2

provided selectvalue2

0

To calculate the profit percentage, consider the following example-

Cost price in cell A1. Selling price in B1.

In C1 (Profit percentage) put
=(B1-A1) / A1

and format C1 as percentage (right-click on C1, Format cells, percentage).

0

Calculating the profit
Eg: (A-B)/B

Click on the answer and select the % sign