how to calculate profit

%3CLINGO-SUB%20id%3D%22lingo-sub-1937131%22%20slang%3D%22en-US%22%3Ehow%20to%20calculate%20profit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1937131%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20add%20excel%20formula%20for%20cost%20x's%201.05%20divided%20by%20.70%20%3D%20sell%20price%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1937131%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1937393%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20calculate%20profit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1937393%22%20slang%3D%22en-US%22%3ETo%20get%20Profit%20margin%20the%20easiest%20formula%20is%2C%20%3D(Price-Cost)%2FPrice%20You%20may%20use%20this%20to%20get%20Sale%20price%2C%20Calculate%20the%20sale%20price%2C%20based%20on%20cost%20and%20margin%2C%20%3DCost%2F(1-Margin)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1937644%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20calculate%20profit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1937644%22%20slang%3D%22en-US%22%3EThank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938654%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20calculate%20profit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938654%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883962%22%20target%3D%22_blank%22%3E%40mkokanagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlad%20to%20help%20you%2C%2C%20since%20my%20post%20solves%20the%20issue%2C%20then%20you%20may%20mark%20it%20as%20%3CSPAN%3EB%3C%2FSPAN%3Eest%20Response%20as%20well%20Like.%3C%2FP%3E%3CP%3EKeep%20asking%20%E2%98%BA%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.