Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
algebra by excel | Excel Worksheet Functions | |||
Algebra in Excel | Excel Discussion (Misc queries) | |||
Simple algebra and excel | Excel Worksheet Functions | |||
how do i write a Algebra formula in excel sheet | Excel Discussion (Misc queries) | |||
solving for NPer w/o function (algebra question) | Excel Worksheet Functions |