Hello all.
Could anyone teach me how to find gross salary if I have a net pay of 12,204,000?
The gross is 13,742,520 but I don't know how to build a auto calculate table in excel
<tbody>
</tbody>ex: 13,742,520 goes range 20%. so
below is table range of wage.
<tbody>
</tbody>
<tbody>
</tbody>
Could anyone teach me how to find gross salary if I have a net pay of 12,204,000?
The gross is 13,742,520 but I don't know how to build a auto calculate table in excel
<tbody>
</tbody>
13,742,520 x 20% = 2,748,504 - 1,210,000 = 1,538,504 tax.
13,742,520 - 1,538,504 = 12,204,016
<tbody>
</tbody>
<strike></strike>13,742,520 - 1,538,504 = 12,204,016
<tbody>
</tbody>
below is table range of wage.
from | to | rate | allowance |
0 | 1,200,000 | 0% | |
1,200,001 | 2,000,000 | 5% | -60,000 |
2,000,001 | 8,500,000 | 10% | -160,000 |
8,500,001 | 12,500,000 | 15% | -585,000 |
12,500,001 | 20% | -1,210,000 |
<tbody>
</tbody>
Thank you very much. |
<tbody>
</tbody>
Last edited: