Whole number question

[JohnSearcy]

I have forgotten somewhat, but what is the code to determine if a number is a whole number or not.
In other words:

5 = Whole number
7.86 = Not a whole number

I looked in the help files, but I couldn't find it. What would that be under?

Thanks,
John

 

[tusharm]

While INT (or Int in VBA) is the more intuitive approach to getting the integer part, Excel and VBA's implementation is to round *towards* zero any non-integer number. So, if one were looking to extract only the integer part, TRUNC (or Fix in VBA) is the way to go.

However, in this case all we want to do is check if there is a fraction part. Consequently, any function would work just as well as any other.
INT(x) = x
TRUNC(x) = x
MOD(x) = 0
and in VBA
Fix(x) = x
Int(x) = x

and if one wanted, use FLOOR or CEILING (or the VBA counterparts).

Thanks Tushar,

I was asking about INT vs TRUNC, because if TRUC is better, then in VBA one should probably use Fix instead of Int

If Fix(x) = x Then

Sounds like they will both work fine and I appreciate your advice of MOD as an additional formula option.

 

[Jerry Sullivan]

Thank you for the clarification.