# Roundt from hundreds to nearest whole Number

#### Harold R.

##### Board Regular
OHRM 303 Test01_05.xls
BCDEFGHIJKLMN
98:00 12:03 12:58 17:00   8.08
108:00 12:02 12:58 15:00   6.07
January_05

How can I round N to the whole Number if it is within.15 on either side of the whole number?

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
NN = if(abs(N-int(N))<=0.15,int(N),N)

Thanks it worked great.

OHRM 303 Test01_05.xls
NOPQ
106.576.570.002.00
1111.0311.003.002.00
January_05
Is there a way to make this formula round to the nearest .25?

=MROUND(A1,0.25)

That didn't work I must be doing something wrong. I get a message of undefined in the pull down box.

Analysis toolpack must be enabled.

Thanks that did work but I am still not explaining what I need very well. If the Number in N is (Whole Number) plus or minus .12 I want it to round to Whole Number. What do I need to substitute to make it work.

???

But it does that.

This is a formula that is in another part of the worksheet before minutes are converted to hundreths:=ROUND(B9/(LOOKUP(MINUTE(B9),{0,15;8,1;23,15;38,1;53,15})/1440),0)*(LOOKUP(MINUTE(B9),{0,15;8,1;23,15;38,1;53,15})/1440) The rule I am trying to capture is if an employee sigs out 7minutes(or .12) before or after the hour the time is rounded to the nearest hour in hundreths.

Replies
8
Views
274
Replies
3
Views
225
Replies
9
Views
143
Replies
9
Views
196
Replies
7
Views
402

1,196,516
Messages
6,015,664
Members
441,914
Latest member
VBAllTheThings

### 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.

### Which adblocker are you using?

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

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