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)