Check if Range is Integer / whole number

[omairhe]

Hello Excel Gurus,

How do I check if my range. Example A3:A10 consists of any integer / whole number values. From helpful forums I was able to get the formula =int(A3)=A3 .However this will check just a single cell and not the entire range. The INT formula is great as it is also a substitute for ISNUMBER formula. However the decimal is not a requirement currently.

Thanks a lot and will appreciate plenty.
Anyone?

 

[Fluff]

How about

=SUMPRODUCT((A3:A10<>"")*(INT(A3:A10)=A3:A10))

 

[mikerickson]

Try = (INT(SUMSQ(A3:A10))=SUMSQ(A3:A10)) will test if all the cells in A3:A10 are integers (or text)

The CSE formula =(PRODUCT(A3:A10-INT(A3:A10))=0) will return True if any cell in A3:A10 is an integer