Nov 27 2020 04:16 PM
How to add excel formula for cost x's 1.05 divided by .70 = sell price
Thanks!
Nov 27 2020 11:54 PM - edited Nov 29 2020 06:17 AM
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)
Nov 29 2020 06:15 AM
Glad to help you,, since my post solves the issue, then you may mark it as Best Response as well Like.
Keep asking ☺
Nov 29 2020 06:34 AM - edited Nov 29 2020 06:37 AM
@mkokanagan Your exact question was "how to add a formula". Perhaps this helps (based on your example):