Getting Rid Of Fractions


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.

SPONSORED VIDEO

How KPMG is innovating the audit

KPMG's global audit team is using cognitive technology and alliances with tech and university partners to drive audit innovation. See how.

SPONSORED REPORT

States look to unclaimed property for revenue

This free report outlines the escheat process, common types of AUP, how different states are handling it and how companies can plan for potential audits and liabilities.