G
Guest
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
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