Identify Whole Number
 

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?

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?

Identify Whole Number
 

=IF(INT(A1)=A1,"YES","NO")

ileanardz wrote:

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?

Identify Whole Number
 

=A1=INT(A1)

--
Biff
Microsoft Excel MVP


"Luke M" wrote in message
...
=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?

Identify Whole Number
 

On Feb 24, 11:27*am, ileanardz wrote:
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?

Thank you all.

While you were answer me, I searched and found what I need he

http://groups.google.com/group/micro...97b20 9ccd85b

Thanks a lot!

Identify Whole Number
 

how about
=if(rounddown(a1,0)=a1,"Yes","No").

Rounddown will round a number down to the specified number of digits.

Allen.

"ileanardz" wrote:

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