Hi

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

Arvi Laanemets


"Wind54Surfer" wrote in message
...
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