[newbie] solving algebra in excel
 

I would like to automatically compute a 'net wage to gross wage' on a
calculation based on some algebra.

Basically the calculation is a function that calculates the gross salary
based on the net salary provided:

1. net salary + ssc rate * gross salary + (tax rate * gross salary) - tax
deduction
= gross salary
2. Solve the equation using algebra. So for example, assuming:

SSC rate = 10%
tax rate = 15%
tax deduction = 1275
net salary = $9690.19

Then the gross salary = net salary / 0.75 = $11220.25

Any ideas?


Related links:
http://www.ird.gov.mt/ - tax and ssc rates

[newbie] solving algebra in excel
 

As in Algebra, move Gross salary to one side of the equation, and THEN
set up the formula.

Jon wrote:
I would like to automatically compute a 'net wage to gross wage' on a
calculation based on some algebra.

Basically the calculation is a function that calculates the gross salary
based on the net salary provided:

1. net salary + ssc rate * gross salary + (tax rate * gross salary) - tax
deduction
= gross salary
2. Solve the equation using algebra. So for example, assuming:

SSC rate = 10%
tax rate = 15%
tax deduction = 1275
net salary = $9690.19

Then the gross salary = net salary / 0.75 = $11220.25

Any ideas?


Related links:
http://www.ird.gov.mt/ - tax and ssc rates