function to find if a number is whole

  • Thread starter Thread starter ::Cory::
  • Start date Start date
C

::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::
 
=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::
|
|
 
Unless I am dense, neither of these replies worked.

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

::CORY::
 
<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::
| >
|
|
 
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
 
Back
Top