[newbie] solving algebra in excel

J

Jon

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
 
B

Bob I

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top