=IIF(h2 = WholeNumber, "XX","YY")?

TEAMRacing · Aug 15, 2003

Is there any way for excel (or vba) to recognize a cell as
a whole number? Any help would be much appreciated.

Peo Sjoblom · Aug 15, 2003

=IF(INT(H2)=H2,"xx","yy")

jason · Aug 15, 2003

try this..
=IF(h2-INT(h2)=0,"whole","not whole")