# Partial Rounding

#### Harold R.

##### Board Regular
Fairwind thanks for the formula, It does part of what I want but as usual I didn't explain very well. The Formula you gave me: =MROUND(A1,0.25) Does round the number to the closest.25. After pluging it into my worksheet I realized that I only want to Round up from .88 up to the next whole Number and round down from .12 to the next whole number. I hope this is the last question I have to bug anyone with for awhile.

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
=IF(ABS(ROUND(A1,0)-A1)<0.12,ROUND(A1,0),A1)

What do you want to do if the fractional part of the number is greater than .12 and less than .88?

Then just show the number as it is entered.

Hi,

=IF(ABS(ROUND(A1,0)-A1)<0.13,ROUND(A1,0),A1)

should do.

The formula returns a 0 but I need it to return the whole number ie:7.88=8.00 or 8.12=8.00

Fairwind Thanks very much it works great. As I said I hope not to bother anyone for awhile. This Forum is an unbeliveable help.

Replies
3
Views
166
Replies
0
Views
215
Replies
1
Views
311
Replies
2
Views
172
Replies
1
Views
120

1,196,030
Messages
6,012,962
Members
441,741
Latest member
jlburn

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