Microsoft KB Archive/61275

-

{| 2.x 3.00 4.00 4.00a 5.00 | 2.20 2.21 3.00 WINDOWS                 | OS/2 kbusage The information in this article applies to:
 * width="100%"|


 * Microsoft Excel for Windows, version 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 versions 2.2, 2.21, 3.0

SUMMARY
The following is a worksheet function that will determine whether a number is real or an integer:

=IF(TRUNC(A1)=A1,&quot;Integer&quot;,&quot;Real&quot;)

MORE INFORMATION
Note that this function will return a #VALUE! error if A1 contains text and &quot;Integer&quot; if A1 is empty. An integer is a number that does not have a fractional value (for example, 8). A real number may contain a fractional value (for example, 5.24).
 * }

-

Last reviewed: November 4, 1994

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.