ROUNDING UP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
=ROUNDUP(x/2,0)*2
will round x to the closest even integer that at least as large as x.

Jerry
 
Back
Top