Test for integers

[shinobi]

Hi

Is there a function in Excel that allows me to check whether a value is an integer or not?

Thanks!

 

[Greg Truby]

<ul>[*]=Int(A1)=A1[/list]

 

[shinobi]

Thanks. It doesn't quite work with numbers that would be rounded up - eg 14.9...

 

[shinobi]

apologies, I'm talking nonsense (forgot to press F9...)

Thanks again

 

[Greg Truby]

JFYI - If you catch an "oops" like that after you post (and we've all made them) and it's before anyone else has posted (i.e. you are the last person to have posted on the thread), you will see a small "x" button over by the edit and quote buttons. Click that to delete the post altogether and make the evidence against you disappear.