More Rounding…

Last week we discussed the use of the CEILING and FLOOR rounding functions. Those are, of course, Not All that is available when it comes to controlling your Precision in Excel. We will look at the INT, EVEN, and ODD functions.

=INT(number)

This function rounds the number down to the nearest integer. Many possible applications, including staffing of projects.

=Even(number)

Using this function, your number rounds away from zero to the nearest even integer. If your staffing requires pairs of individuals working together, this may be just your ticket.

=ODD(number)

As you might expect, this function always rounds away from zero to the nearest odd integer. Undoubtedly useful in certain Odd situations (sorry, I couldn’t resist…).

INT, EVEN, and ODD. More ways to round your data your way in Excel.