how to calculate profit

Copper Contributor

How to add excel formula for cost x's 1.05 divided by .70 = sell price

Thanks!

5 Replies

To get Profit margin the easiest formula is,

 

=(Price-Cost)/Price

 

You may use this to get Sale price, Calculate the sale price, based on cost and margin,

 

=Cost/(1-Margin)

Thank you!

@mkokanagan 

 

Glad to help you,, since my post solves the issue, then you may mark it as Best Response as well Like.

Keep asking ☺

@mkokanagan Your exact question was "how to add a formula". Perhaps this helps (based on your example):

Screenshot 2020-11-29 at 15.32.29.png

Thanks Riny. That's nice and simple.