Prev: Splitting data in a cell
Next: 4 field lookup
From: ileanardz on 24 Feb 2010 12:27
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?
From: Luke M on 24 Feb 2010 12:50
=IF(A1=INT(A1),TRUE,FALSE)

--
Best Regards,

Luke M
"ileanardz" <ileanardz(a)gmail.com> wrote in message
news:cf438d6d-b2c8-4191-961f-69909be1a53a(a)g28g2000yqh.googlegroups.com...
> 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?


From: T. Valko on 24 Feb 2010 12:59
=A1=INT(A1)

--
Biff
Microsoft Excel MVP


"Luke M" <lukemoraga(a)nospam.com> wrote in message
news:%23p7ognXtKHA.4220(a)TK2MSFTNGP05.phx.gbl...
> =IF(A1=INT(A1),TRUE,FALSE)
>
> --
> Best Regards,
>
> Luke M
> "ileanardz" <ileanardz(a)gmail.com> wrote in message
> news:cf438d6d-b2c8-4191-961f-69909be1a53a(a)g28g2000yqh.googlegroups.com...
>> 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?
>
>


From: Bob I on 24 Feb 2010 12:59
=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?

From: ileanardz on 24 Feb 2010 13:03
On Feb 24, 11:27 am, ileanardz <ileana...(a)gmail.com> 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 here:

http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/928b1f3226085718/4e4b97b209ccd85b?lnk=gst&q=whole+numbers#4e4b97b209ccd85b

Thanks a lot!
 |  Next  |  Last
Pages: 1 2
Prev: Splitting data in a cell
Next: 4 field lookup