Thread: ROUNDING UP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Novice2000 Novice2000 is offline
external usenet poster
 
Posts: 9
Default 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)?