keith8558Copper ContributorMay 26, 2023excel formulaHello, i am wanting to understand how to create a formula to calculate a 45% margin the way the calculator does it. Example: calculator= 100 "cost" 45 margin = 181.81
2 RepliesReplies sorted by NewestHansVogelaarMVPMay 26, 2023keith8558 Enter 100 in A2 and 45% in B2. In C2, enter the formula =A2/(100%-B2)mtarlerSilver ContributorMay 26, 2023I believe you want Cost / (1 - Margin)
HansVogelaarMVPMay 26, 2023keith8558 Enter 100 in A2 and 45% in B2. In C2, enter the formula =A2/(100%-B2)