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

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password