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

 

[T. Valko]

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

One way...

A1 = some number

=A1-INT(A1)=0

 

[Jerry Sullivan]

John, One method is:

If Int(x) = x Then

where True means it is a whole number.

 

[Jerry Sullivan]

John, One method is:

If Int(x) = x Then

where True means it is a whole number.

P.S. I didn't see Biff's note until I posted this. This is a VBA approach if that is what you are asking.

 

[JohnSearcy]

What I was looking for. Thanks to both of you!!

 

[T. Valko]

What I was looking for. Thanks to both of you!!

You're welcome. Thanks for the feedback!

 

[Aladin Akyurek]

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

Real numbers is a much larger set. Therefore:

=A1-TRUNC(A1)=0

 

[Jerry Sullivan]

Real numbers is a much larger set. Therefore:

=A1-TRUNC(A1)=0

Aladin, is there a case where this would return a different result than the formula Biff suggested?

When A1 is a negative number, the value of A1-TRUNC(A1) will be different than A1-INT(A1); however it would appear to still return True only for whole numbers.

 

[tusharm]

Nothing wrong with any of the responses you've received, but I find the two below more 'direct.'
=MOD(A1,1)=0. This works because Excel supports real numbers in the MOD function.
=A1=INT(A1) This also works in VBA, as has already been pointed out.

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

 

[Jerry Sullivan]

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.