1. column
  2. TECHNOLOGY Q&A

Getting Rid Of Fractions

Please note: This item is from our archives and was published in 2000. It is provided for historical reference. The content may be out of date and links may no longer function.

Related

No Results

TOPICS

    Uncategorized Article

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:

=INT(19.47)

Using this formula, Excel returns a value of 19. INT always returns the next lower whole number, or integer.