solving of linear equation

[Stan]

Hello All,
Let me describe my problem first: I have an array (X) in column which
is net salary of a staff and need to caculate gross for further
calculation of witholdes from salary and social taxes from employer.
Thus I need to calculate Y - gross in another array. The equation for X
is folowing:
X = Y - (Y-(Y*2%)-(Y*1%)-(Y*0,5%))*13%-(Y*2%)-(Y*1%)-(Y*0,5%)
the equations also has constraint: if Y>=4960, then Y should be
substituted with 4960 in equation, because it is maximum taxable
amount. So I need to solve linear equation for Y
Could somebody give an advice how i can do this. I'll be appreciated
for any help...

 

[Guest]

Y=X/0.83955

maximizing Y: X=MIN(X/0.83955,4960)

Regards,
Stefi

„Stan†ezt írta:

 

[Stan]

Thank you, Stefi,
but I have some hesitation about solution that you give, because after
Y >=limited amount for taxes, which are substracted (0,5%, 2%, 1%),
profit tax (13%) is applied to difference between gross salary and
gross withholdes.

Net=Gross-(Gross-(limit*2%)-(limit*1%)-(limit*0,5%))*13%-(limit*2%)-(limit*1%)-(limit*0,5%)

So we have here not asolute line dependence.... It will be line till
gross doesn't exceed limit for withhold taxes. Sorry if I express not
very clear. Hope you'll get my idea

 

[Stan]

Thank you, Stefi,
but I have some hesitation about solution that you give, because after
Y >=limited amount for taxes, which are substracted (0,5%, 2%, 1%),
profit tax (13%) is applied to difference between gross salary and
gross withholdes.

Net=Gross-(Gross-(limit*2%)-(limit*1%)-(limit*0,5%))*13%-(limit*2%)-(limit*1%)-(limit*0,5%)

So we have here not asolute line dependence.... It will be line till
gross doesn't exceed limit for withhold taxes. Sorry if I express not
very clear. Hope you'll get my idea

 

[Guest]

net:A1
limit:C1
then

gross=(A1+0.03045*C1)/0.87


Regards,
Stefi

„Stan†ezt írta:

 

[Stan]

ok, thank you Steffi
frankly saying i supposed to get any ideas about solution of of such
equation not in a way of simplication but more detailed. any way again
thanks for assistance