=ROUNDUP(A16/2,0)*2
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|