Payroll - net to gross?

[CD]

I made a simple sheet to calculate net pay from gross.

D1 is dollar amount of gross income. (manually entered)

D4 thru D9 are the dollar amount of deductions, (calculated figures that are
the result of numbers in A4 thru A9 multiplied by D1, the gross pay)

D10 is total deductions (sum of D4 thru D9)

D11 is the net pay (D1 minus D10)

What I want to do now is make a second calculator that goes backwards - one
where I can enter a NET pay and calculate what the gross was, but math was
never my best subject so I'm not sure where to start. I'd like to be able to
just copy what i have and change the formulas, if that's possible.

Thanks,
CD

 

[Biff]

Hi!

Basically, what you want to do can't be done. At least,
not the way you're thinking.

I can enter a NET pay and calculate what the gross was

You can't calculate the deductions unless you know what
the gross was!

Assume the net pay was $500 and deduction1 is 28%. If you
don't have the amount of deduction1 you can't calculate a
gross pay and you can't calculate deduction1 if you don't
know the gross pay.

Biff

 

[CD]

Thanks. Thats actually the answer I expected, that it couldn't be done, but
ya' never know.

CD

 

[garfield-n-odie]

If D4 through D9 are all percentages of D1, then it IS possible. D1 =
D11/(1-(SUM(D49)). But if one of the deductions is U.S. federal
income tax, then that number should be a lookup, not a percentage, and
the backward formula won't work.