Forum Discussion
mkokanagan
Nov 28, 2020Copper Contributor
how to calculate profit
How to add excel formula for cost x's 1.05 divided by .70 = sell price
Thanks!
5 Replies
- Riny_van_EekelenPlatinum Contributor
mkokanagan Your exact question was "how to add a formula". Perhaps this helps (based on your example):
- mkokanaganCopper ContributorThanks Riny. That's nice and simple.
- Rajesh_SinhaIron Contributor
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)
- mkokanaganCopper ContributorThank you!
- Rajesh_SinhaIron Contributor
Glad to help you,, since my post solves the issue, then you may mark it as Best Response as well Like.
Keep asking ☺