function to find if a number is whole

[::Cory::]

Does anyone know of a function to determine if a number is a whole integer
and not a decimal place?

I want to target a cell (that has a sum value in it) and create an if
statement if it's a whole number or not.

::CORY::

[SteveW]

Assume A1 has number in it

=3Dif( INT(a1)=3Da1, True, False)

On Tue, 15 Aug 2006 20:05:56 +0100, ::Cory:: <no_ka_oii@hotmail.com> wro=
te:

> Does anyone know of a function to determine if a number is a whole =

> integer
> and not a decimal place?
>
> I want to target a cell (that has a sum value in it) and create an if
> statement if it's a whole number or not.
>
> ::CORY::
>
>



-- =

Steve (3)

[Niek Otten]

=MOD(A1,1)=0

Returns TRUE or FALSE

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"::Cory::" <no_ka_oii@hotmail.com> wrote in message news:%23ZcDR3JwGHA.1436@TK2MSFTNGP02.phx.gbl...
| Does anyone know of a function to determine if a number is a whole integer
| and not a decimal place?
|
| I want to target a cell (that has a sum value in it) and create an if
| statement if it's a whole number or not.
|
| ::CORY::
|
|

[::Cory::]

Unless I am dense, neither of these replies worked.

A1 value is 4.00 on my sheet is that my problem?

::CORY::



"::Cory::" <no_ka_oii@hotmail.com> wrote in message
news:%23ZcDR3JwGHA.1436@TK2MSFTNGP02.phx.gbl...
> Does anyone know of a function to determine if a number is a whole integer
> and not a decimal place?
>
> I want to target a cell (that has a sum value in it) and create an if
> statement if it's a whole number or not.
>
> ::CORY::
>

[::Cory::]

Nevermind. I found my error.

Thanks for the fast help guys!

::CORY::


"::Cory::" <no_ka_oii@hotmail.com> wrote in message
news:%23Zu2YAKwGHA.4972@TK2MSFTNGP05.phx.gbl...
> Unless I am dense, neither of these replies worked.
>
> A1 value is 4.00 on my sheet is that my problem?
>
> ::CORY::
>
>
>
> "::Cory::" <no_ka_oii@hotmail.com> wrote in message
> news:%23ZcDR3JwGHA.1436@TK2MSFTNGP02.phx.gbl...
>> Does anyone know of a function to determine if a number is a whole
>> integer and not a decimal place?
>>
>> I want to target a cell (that has a sum value in it) and create an if
>> statement if it's a whole number or not.
>>
>> ::CORY::
>>
>
>

[Niek Otten]

<A1 value is 4.00>

It probably isn't; 4.00 is what it shows, not what the value is. Format A1 as General and widen the column to its maximum. What do
you see?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"::Cory::" <no_ka_oii@hotmail.com> wrote in message news:%23Zu2YAKwGHA.4972@TK2MSFTNGP05.phx.gbl...
| Unless I am dense, neither of these replies worked.
|
| A1 value is 4.00 on my sheet is that my problem?
|
| ::CORY::
|
|
|
| "::Cory::" <no_ka_oii@hotmail.com> wrote in message
| news:%23ZcDR3JwGHA.1436@TK2MSFTNGP02.phx.gbl...
| > Does anyone know of a function to determine if a number is a whole integer
| > and not a decimal place?
| >
| > I want to target a cell (that has a sum value in it) and create an if
| > statement if it's a whole number or not.
| >
| > ::CORY::
| >
|
|

[SteveW]

If the value is 4.0 and displayed as 4.00 - no problem
if on the other hand the value is 4.001 and formated to show 2 decimal =

places then yes it's correct

modify the formula to this

=3Dif( abs(int(a1)-a1)<0.000001, true, false)

You can *alter the accuracy* by altering the 0.000001

Steve


On Tue, 15 Aug 2006 20:22:16 +0100, ::Cory:: <no_ka_oii@hotmail.com> wro=
te:

> Unless I am dense, neither of these replies worked.
>
> A1 value is 4.00 on my sheet is that my problem?
>
> ::CORY::
>
>
>
> "::Cory::" <no_ka_oii@hotmail.com> wrote in message
> news:%23ZcDR3JwGHA.1436@TK2MSFTNGP02.phx.gbl...
>> Does anyone know of a function to determine if a number is a whole =

>> integer
>> and not a decimal place?
>>
>> I want to target a cell (that has a sum value in it) and create an if=

>> statement if it's a whole number or not.
>>
>> ::CORY::
>>
>
>



-- =

Steve (3)