Prev: Splitting data in a cell
Next: 4 field lookup
From: Allen on 24 Feb 2010 13:21
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?
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Splitting data in a cell
Next: 4 field lookup