Salary | 11% | Payroll Website Result |
RM 3460 | RM 380.60 | RM 381.00 |
RM 3470 | RM 381.70 | RM 383.00 |
RM 3480 | RM 382.80 | RM 383.00 |
RM 3490 | RM 383.90 | RM 385.00 |
<tbody>
</tbody>
dear all,
I'm doing a manual excel formula payroll therefore I faced an issues that the calculation of 11% couldn't be the same as the payroll website.
1st Question:
If I used =A1*11% i will get the result as in table column 11% but when I check in the website it shows different amount. It seems to go to the nearest +2 figure, u can notice RM 3470 & RM 3480 shared the same amount of RM 383, but excel give me different amount. May I know is there any formula in excel can achieve the result?
2nd Question:
If the result can be achieved, I need the format to be RM 383.00 with two decimal point figure.
Any advise for this will be much appreciated.