ROUNDING UP
 

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)?

ROUNDING UP
 

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

Jerry

"Novice2000" wrote:

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)?

ROUNDING UP
 

Thank you. That is exactly what I needed.

"Jerry W. Lewis" wrote:

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

Jerry

"Novice2000" wrote:

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)?