ROUNDING UP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Novice2000 - 10 Oct 2006 13:52 GMT

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

Reply to this Message

Jerry W. Lewis - 10 Oct 2006 14:09 GMT

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

Jerry

> 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
[quoted text clipped - 5 lines]
> everything is rounded up to the nearest even integer?
> =EVEN(3), =EVEN(2), and =EVEN(-1)?

Reply to this Message

Novice2000 - 10 Oct 2006 14:14 GMT

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.
[quoted text clipped - 10 lines]
> > everything is rounded up to the nearest even integer?
> > =EVEN(3), =EVEN(2), and =EVEN(-1)?

Reply to this Message