excel formula

Copper Contributor

Hello,

 

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 Replies
I believe you want Cost / (1 - Margin)

@keith8558 

Enter 100 in A2 and 45% in B2.

In C2, enter the formula =A2/(100%-B2)