# Check if Range is Integer / whole number

#### omairhe

##### Well-known Member
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?

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=SUMPRODUCT((A3:A10<>"")*(INT(A3:A10)=A3:A10))``

#### mikerickson

##### MrExcel MVP
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

Replies
7
Views
228
Replies
6
Views
120
Replies
19
Views
331
Replies
0
Views
97
Replies
6
Views
191

1,127,653
Messages
5,626,101
Members
416,161
Latest member
David1966Lewis

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back