How to Check if a Whole Number can be divided by another number
To check if one a whole number is divisible by another number, we will be using the IF function in combination with the INT function. In our example, we will be checking if certain numbers are divisible by 4 without leaving a remainder. Here is how we’ll achieve this:
To see if a whole number can be divided by 4
- Select cells A1:A10 and type the following formula: =IF(INT(B1/4)=B1/4,”Divisible by 4″,”not divisible”).
- Press CTRL+Enter.
This will return “Divisible by 4″ if the criteria is true, otherwise it will return “not divisible”. Found this useful? Please leave a comment.
- Using the OR function to check cells for text or numbers in Excel
- How to Use the FIXED function to round and convert numbers
- Use the ISEVEN and ISODD functions to check if a number is even or odd
- How to Check for Valid Numbers Using the T Function in Excel
- How to Extract digits from a cell using the MID Function in Excel
