Forum Discussion

mkokanagan's avatar
mkokanagan
Copper Contributor
Nov 28, 2020

how to calculate profit

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

Thanks!

5 Replies

  • Rajesh_Sinha's avatar
    Rajesh_Sinha
    Iron 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)

Resources