View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default function to find if a number is whole

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