# Formula to Calculate Back and Forth Between Net & Gross Based on Markup Percentage

I'm trying to develop a cost management spreadsheet for my company. The way we currently manage budgets is by taking the total budget from the proposal (Gross), subtracting our cut, then getting the monthly spend (Net).

At the end of the month, we then go in and input the actual spend for that month (Net) and bill clients based on actual spend + our cut (Gross).

So I essentially need to be able to calculate from Gross to Net, then back to Gross. I've got formulas that work backward and forward - but they don't calculate out to match what calculates in this Markup Calculator: https://www.omnicalculator.com/business/markup

If Gross = G, Net = N, Markup = M

I've got:

G = N+(N*M)/100


But when I try to work that backward, I get all screwed up. I'm writing:

N = G-(G*M)/100


• I am confused about your $N$. Did you mean to get Wolfram Alpha? – Moo Aug 14 '18 at 17:49
$$G=N+\frac {NM}{100}\\G=N\left(1+\frac M{100}\right)\\\frac G{1+\frac M{100}}=N$$