percentage round up to nearest decimal point with range

ahjeff86

New Member
Joined
Sep 26, 2018
Messages
15
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Salary[/TD]
[TD]11%[/TD]
[TD]Payroll Website Result[/TD]
[/TR]
[TR]
[TD]RM 3460[/TD]
[TD]RM 380.60[/TD]
[TD]RM 381.00[/TD]
[/TR]
[TR]
[TD]RM 3470[/TD]
[TD]RM 381.70[/TD]
[TD]RM 383.00[/TD]
[/TR]
[TR]
[TD]RM 3480[/TD]
[TD]RM 382.80[/TD]
[TD]RM 383.00[/TD]
[/TR]
[TR]
[TD]RM 3490[/TD]
[TD]RM 383.90[/TD]
[TD]RM 385.00[/TD]
[/TR]
</tbody>[/TABLE]









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.
 
You'll want to use a VLOOKUP like so:

=VLOOKUP(E1,$A$2:$C$10,3,TRUE)
 
Upvote 0

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Depends on where you put the VLOOKUP.

You either do

=VLOOKUP(sheetname!E1,$A$2:$C$10,TRUE) <- VLOOKUP located on sheet EPF

Or

=VLOOKUP(E1,EPF!$A$2:$C$10,TRUE) <- VLOOKUP located on the other sheet with E1

If your other sheet name has spaces, then you must do this: 'sheet name'! with single quotes.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top