View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default function to find if a number is whole

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)