Profit percentage calculation

Mycelus · 08/22/21

Hey all. Trying to get a profit percentage formula.

Columns are:

"Price Bought" "Price Sold"

I want to get the profit between the bought and sold, so if I bought for $1200 and sold for $1000, that's 20% profit ($1200 / $1000 = 1.2)

What's the correct way to do this?

Mike L. · 08/22/21

I calculated profit percentas income minus expense divided by income is outlined here. https://www.pdfconverter.com/resources/blog/calculate-profit-excel

Looks like you lost money.

=(1000-1200)/1000 = -20% (loss)

=([Price Sold]@row - [Price Bought]@row) / [Price Sold]@row

The syntax should be the same regardless of how you calculate.

This is a uniform formula that will work for your entire sheet.

Price Sold minus Price Bought should be in parentheses because the order of operation is division&multiplication before addition&subtraction.

The answer is a decimal but you can format the column as %.

Mike L. · 08/22/21