View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default 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?