Excel VBA If statement question

[gallupd@aetna.com]

I am trying to write an IF statement that will take another cell and
tell me if that cell is a whole number or not. The statemnet I
currently have that does not work is :

=IF(M4 = "*.*","1","0")

where M4 is a cell with a value (in my case 0.04). I am not sure if
the "*.*" is the correct syntax or not to find out if the number is
whole or not. Any insight would be appreciated.

Drew

[Toppers]

Try:

=If(mod(m4,1)=0,"True","False")

HTH

"gallupd@aetna.com" wrote:

> I am trying to write an IF statement that will take another cell and
> tell me if that cell is a whole number or not. The statemnet I
> currently have that does not work is :
>
> =IF(M4 = "*.*","1","0")
>
> where M4 is a cell with a value (in my case 0.04). I am not sure if
> the "*.*" is the correct syntax or not to find out if the number is
> whole or not. Any insight would be appreciated.
>
> Drew
>
>

[Doug Glancy]

Drew,

I wasn't sure which result "1" would indicate:

=IF(INT(M4)=M4,"whole","fraction")

hth,

Doug

<gallupd@aetna.com> wrote in message
news:1123860505.187906.17280@z14g2000cwz.googlegroups.com...
>I am trying to write an IF statement that will take another cell and
> tell me if that cell is a whole number or not. The statemnet I
> currently have that does not work is :
>
> =IF(M4 = "*.*","1","0")
>
> where M4 is a cell with a value (in my case 0.04). I am not sure if
> the "*.*" is the correct syntax or not to find out if the number is
> whole or not. Any insight would be appreciated.
>
> Drew
>