# 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?

Tags:

• ✭✭✭

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 %.

• ✭✭✭

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 %.

• ✭✭

Haha, I totally wrote that wrong, but yes thank you, this worked great!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!