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.

=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.

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.

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.