Can using If Formula differentiate number with decimal or do not

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
What are the rules for how the other number is derived?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top