hey dafan, thanks.
how would i convert this to some vba code?
Sub macro1()
MsgBox IIf(Int([a1]) = [a1], "Whole", "Not")
End Sub
Code:If 110 Mod 20 > 0 Then: MsgBox "not whole"
is good enough right?
MsgBox IIf([MOD(A1,1)], "Not", "Whole")