This formula divides the value in cell A1 by the value in cell B1. The dollar amount of the gain or loss is divided by the original purchase. Ie there is a net loss percentage of 10 10.
CP frac 100100P 100m 100n In case of loss CP frac 100100P 100-m 100-n If P and L are equal then PL.
Ie there is a net loss percentage of 10 10. Multiply 0213 by 100 to get 213 percent. Formula for percentage The formula for percentage is the following and it should be easy to use if you follow the straightforward directions given. If we have these values supplied we can easily calculate the percentage gain or loss in Excel.