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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!