ROUNDING UP

[Novice2000]

I have a fee that needs to be rounded up to the nearest even integer, since
the fee is billed in two halves and my boss wants 2 even billings. The
following rounds 1.5 up to 2:

=EVEN(1.5) so that 1.67 is rounded to 2

How can I add the other rounding formulas to this same column so that
everything is rounded up to the nearest even integer?
=EVEN(3), =EVEN(2), and =EVEN(-1)?

 

[Jerry W. Lewis]

=ROUNDUP(x/2,0)*2
will round x to the closest even integer that at least as large as x.

Jerry

 

[Novice2000]

Thank you. That is exactly what I needed.

=ROUNDUP(x/2,0)*2
will round x to the closest even integer that at least as large as x.

Jerry