View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gallupd@aetna.com is offline
external usenet poster
 
Posts: 1
Default Excel VBA If statement question

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