Hello All,
Let me describe my problem first: I have an array (X) in column which
is net salary of a staff. It's needed to caculate gross for further
calculation of witholdes from salary and social taxes from employer.
The equation for X is folowing:

X = if(Y<4960;Y-(Y-(Y*2%)-(Y*1%)-(Y*0,5%))*13%-(Y*2%)-(Y*1%)-(Y*0,5%));Y - (Y-(4960*2%)-(4960*1%)-(4960*0,5%))*13%-(4960*2%)-(4960*1%)-(4960*0,5%))

or simpified form

X = if(Y<4960;Y-(Y-(Y*3,5%))*13%-(Y*3,5%));Y-(Y-(173,6))*13%+173,6)

where Y is gross salary

it can be sipified further of course...


You see the equations also has constraint: if Y>=4960, then Y should be
substituted with 4960 in equation, because it is maximum taxable
amount.
I need to build array for Y....
Could somebody give an advice or idea how i can do this. I'll be appreciated
for any help... It's seemed that Solver adds-in can help there but I need instructions of using it