Goal seek and solver are great to solve this equation, but I need to see the formula for further manipulation. Any ideas? Any help is appreciated.
50,000 revenue
00000 discount
-10,000 cogs
40,000 profit
80% margin
60% target margin
Solve to find maximum discount to achieve target margin
50,000 revenue
00000 discount
-10,000 cogs
40,000 profit
80% margin
60% target margin
Solve to find maximum discount to achieve target margin