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.

Can using If Formula differentiate number with decimal or do not
 

=If(INT(A1)=A1, "Integer","Not Integer")

NickHK

"ShamsulZ" wrote in message
...
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.

Can using If Formula differentiate number with decimal or do not
 

What are the rules for how the other number is derived?

--
HTH

Bob Phillips

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

"ShamsulZ" wrote in message
...
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.

Can using If Formula differentiate number with decimal or do not
 

Thanks a lot to Nick HK. Bob pls refer the formula that Nick gave. Cheers!

"ShamsulZ" wrote:

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.