check if whole num

[codesmith]

Hey all - just wondering how I can check if a value is a whole number or not?

thanks in advance.

 

[dafan]

If your number you want to test is in A1:

=IF(MOD(A1,1)>0,"Not","Whole")

Change Not and Whole to whatever you'd like to return.

There might be other methods but this is the one I could come up with

 

[codesmith]

hey dafan, thanks.

how would i convert this to some vba code?

 

[codesmith]

never mind, found out how to use Mod - thanks.

 

[northwolves]

hey dafan, thanks.

how would i convert this to some vba code?

Sub macro1()
MsgBox IIf(Int([a1]) = [a1], "Whole", "Not")
End Sub

Regards
Northwolves

 

[codesmith]

If 110 Mod 20 > 0 Then: MsgBox "not whole"

is good enough right?

 

[northwolves]

If 110 Mod 20 > 0 Then: MsgBox "not whole"

is good enough right?

It must be wrong.

 

[northwolves]

You can use the following instead.

MsgBox IIf([MOD(A1,1)], "Not", "Whole")

Regards
Northwolves

 

[codesmith]

but it works ... can someone else provide any more input?