I need help rounding numbers, please.

Hi everyone,

I need to round numbers as part of a formula and can't figure it out.

Say I have 72.5 and need to divide it into 3

I get 24.16 (then I need to round 24.6 to the next even number = 26)

(Anything over an even must go to the next even.)

Any ideas really appreciated.

Thanks,
Emilio

What if the result is odd?

Assuming, based on your example, that you want to round *up* to the
nearest even number, one way:

=CEILING(72.5/3,2)

In article <[email protected]>,
Wind54Surfer <[email protected]> wrote:

> I need to round numbers as part of a formula and can't figure it out.
>
> Say I have 72.5 and need to divide it into 3
>
> I get 24.16 (then I need to round 24.6 to the next even number = 26)
>
> (Anything over an even must go to the next even.)
>
> Any ideas really appreciated.

=ROUNDUP(A16/2,0)*2

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Wind54Surfer" <[email protected]> wrote in message
news:[email protected]...
> Hi everyone,
>
> I need to round numbers as part of a formula and can't figure it out.
>
> Say I have 72.5 and need to divide it into 3
>
> I get 24.16 (then I need to round 24.6 to the next even number = 26)
>
> (Anything over an even must go to the next even.)
>
> Any ideas really appreciated.
>
> Thanks,
> Emilio

Hi

With your number p.e. in A2
=ROUNDUP(A2/(3*2),0)*2

Arvi Laanemets


"Wind54Surfer" <[email protected]> wrote in message
news:[email protected]...
> Hi everyone,
>
> I need to round numbers as part of a formula and can't figure it out.
>
> Say I have 72.5 and need to divide it into 3
>
> I get 24.16 (then I need to round 24.6 to the next even number = 26)
>
> (Anything over an even must go to the next even.)
>
> Any ideas really appreciated.
>
> Thanks,
> Emilio

Thanks a lot to everybody.

I am impress how many people are willing to help.

Thanks again,
Emilio