View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default [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