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).

Mar 05 2014 01:34 PM
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).

Calculating the profit

Eg: (A-B)/B

Click on the answer and select the % sign

Feb 09 2015 10:32 AM
Eg: (A-B)/B

Click on the answer and select the % sign