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