IF <> to integer?

[antman123]

In Excel how would I code a statement that made sure that a variable was an integer. e.g.

IF DeskNumber /= integer THEN

Thanks

 

[cherria]

How about

IF INT(DeskNumber) = DeskNumber THEN
..stuff if desknumber is an integer
ELSE
..stuff if desknumber is not an integer
END IF

 

[Oaktree]

Or, same as Cherria's but with a formula instead of VBA,

=IF(A1=INT(A1),"A1 houses an integer", "A1 does not house an integer")

 

[antman123]

Yes, but its more of a validation thing im trying to get. So if the user types in letters instead of numbers, then the ELSE part is executed (an error msg)

 

[jindon]

Hi,

I think you can use TypeName(variable)

hope this helps

jindon

 

[KenWright]

Something like this perhaps:-

=IF(NOT(ISNUMBER(A1)),"This is text or blank",IF(A1=INT(A1),"Valid Integer","Number with Decimals"))

 

[antman123]

Thanks... That last one that uses ISNUMBER is exactly what i want. Only problem is that I cant use the ISNUMBER bit in VBA. Any ideas?

Thanks

 

[jindon]

Hi

IsNumeric can be used

hope this helps
jindon

 

[inarbeth]

"Yes, but its more of a validation thing im trying to get. So if the user types in letters instead of numbers, then the ELSE part is executed (an error msg)"

You could use Data Validation and either Allow Whole number of Decimal or use a custom formula =ISNUMBER(A1).