function to find if a number is whole

[::Cory::]

Does anyone know of a function to determine if a number is a whole integer
and not a decimal place?

I want to target a cell (that has a sum value in it) and create an if
statement if it's a whole number or not.

::CORY::

 

[SteveW]

Assume A1 has number in it

=if( INT(a1)=a1, True, False)

 

[Niek Otten]

=MOD(A1,1)=0

Returns TRUE or FALSE

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Does anyone know of a function to determine if a number is a whole integer
| and not a decimal place?
|
| I want to target a cell (that has a sum value in it) and create an if
| statement if it's a whole number or not.
|
| ::CORY::
|
|

 

[::Cory::]

Unless I am dense, neither of these replies worked.

A1 value is 4.00 on my sheet is that my problem?

::CORY::

 

[::Cory::]

Nevermind. I found my error.

Thanks for the fast help guys!

::CORY::

 

[Niek Otten]

<A1 value is 4.00>

It probably isn't; 4.00 is what it shows, not what the value is. Format A1 as General and widen the column to its maximum. What do
you see?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Unless I am dense, neither of these replies worked.
|
| A1 value is 4.00 on my sheet is that my problem?
|
| ::CORY::
|
|
|
| | > Does anyone know of a function to determine if a number is a whole integer
| > and not a decimal place?
| >
| > I want to target a cell (that has a sum value in it) and create an if
| > statement if it's a whole number or not.
| >
| > ::CORY::
| >
|
|

 

[SteveW]

If the value is 4.0 and displayed as 4.00 - no problem
if on the other hand the value is 4.001 and formated to show 2 decimal
places then yes it's correct

modify the formula to this

=if( abs(int(a1)-a1)<0.000001, true, false)

You can *alter the accuracy* by altering the 0.000001

Steve