| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA If statement question
Drew,
I wasn't sure which result "1" would indicate: =IF(INT(M4)=M4,"whole","fraction") hth, Doug wrote in message ups.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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement Question | Excel Worksheet Functions | |||
| IF statement question | Excel Worksheet Functions | |||
| IF statement question | Excel Worksheet Functions | |||
| Question about dim statement | Excel Programming | |||
| IF Statement question | Excel Worksheet Functions | |||
Threaded Mode
