Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to calculate gross margins and prices at different levels of GM:
Non-Excel Formula to calculate Selling price using gross margin Selling Price = Cost / (1-GM%) For example, if your product costs $100 and the required gross margin is 40%, then your Selling Price = $100/(1-0.4) = $100/0.6 = $166.6 So in my worksheet E16=cost E17=Current Selling Price I want to put my current GM in F17, I want to get a selling price for GM at: 15% in G16 20% in H16 25% in I16 30% in J16 35% in K16 Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Margins | Excel Discussion (Misc queries) | |||
Margins | Setting up and Configuration of Excel | |||
Margins | Excel Discussion (Misc queries) | |||
Margins | Excel Worksheet Functions | |||
Margins | Excel Discussion (Misc queries) |