Roundup

[weh2oski]

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

 

[Ian Mac]

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)

 

[Steve Hartman]

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)

 

[Fryer Tuck]

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

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

F.T.