# Roundup

#### weh2oski

##### New Member
Ineed to round up to next whole number in increments of 5
Example
22.365 = 25
18.6 = 20

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
On 2002-10-02 09:56, weh2oski wrote:
Ineed to round up to next whole number in increments of 5
Example
22.365 = 25
18.6 = 20

Hi,

Welcome to the board,

try;

=CEILING(A1,5)

On 2002-10-02 09:56, weh2oski wrote:
Ineed to round up to next whole number in increments of 5
Example
22.365 = 25
18.6 = 20

Number to round up in A1:

CEILING(A1,5)

=Int((Number + 4.9) / 5 ) * 5

use as many decimal places at "4.9" as you will use in the origianl number.

F.T.

Replies
1
Views
140
Replies
4
Views
317
Replies
4
Views
199
Replies
2
Views
205
Replies
5
Views
404

1,219,914
Messages
6,150,933
Members
450,994
Latest member
MacOrch

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

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