View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ShamsulZ ShamsulZ is offline
external usenet poster
 
Posts: 23
Default Can using If Formula differentiate number with decimal or do not

The case is like this. I'm doing an analysis that the result will come out as
2 numbers. One with any number with decimal (e.g. 123.456799) and the other
one will come out as integra number (e.g. 1 2 3 4 5 and so on without
decimal). The one with no decimal is the correct answer. When recognising the
no. with no decimal, I want Excel to automatically insert another no. in
other cell. Please help. Thanks a lot friends.