Q. Sometimes I need to work with whole numbers—no rounding up or down. How can I do that ?
A. It’s not well known, but Excel provides such a function—the INT Worksheet Function—which does just that. It takes a single argument and returns the integer value of that argument. For instance, consider the following:
Using this formula, Excel returns a value of 19. INT always returns the next lower whole number, or integer.