Profit percentage calculation
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?
Best Answer

I calculated profit percentas income minus expense divided by income is outlined here. https://www.pdfconverter.com/resources/blog/calculateprofitexcel
Looks like you lost money.
=(10001200)/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 %.
Answers

I calculated profit percentas income minus expense divided by income is outlined here. https://www.pdfconverter.com/resources/blog/calculateprofitexcel
Looks like you lost money.
=(10001200)/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 %.

Haha, I totally wrote that wrong, but yes thank you, this worked great!
Help Article Resources
Categories
Check out the Formula Handbook template!