Identify Whole Number
=IF(A1=INT(A1),TRUE,FALSE)
--
Best Regards,
Luke M
"ileanardz" wrote in message
...
How can excel identify a number when it is whole or it has decimals.
I am doing an IF function.
E.I.
If(A1=WHOLE NUMBER, YES, NO)
Is there some way?
|