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::

Assume A1 has number in it

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

On Tue, 15 Aug 2006 20:05:56 +0100, ::Cory:: wrote:

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::





--
Steve (3)

=MOD(A1,1)=0

Returns TRUE or FALSE

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"::Cory::" wrote in message ...
| 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::



"::Cory::" wrote in message
...
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::

Nevermind. I found my error.

Thanks for the fast help guys!

::CORY::


"::Cory::" wrote in message
...
Unless I am dense, neither of these replies worked.

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

::CORY::



"::Cory::" wrote in message
...
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::

<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


"::Cory::" wrote in message ...
| Unless I am dense, neither of these replies worked.
|
| A1 value is 4.00 on my sheet is that my problem?
|
| ::CORY::
|
|
|
| "::Cory::" wrote in message
| ...
| 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


On Tue, 15 Aug 2006 20:22:16 +0100, ::Cory:: wrote:

Unless I am dense, neither of these replies worked.

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

::CORY::



"::Cory::" wrote in message
...
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::






--
Steve (3)