Use the INT function with the IF function - Logical Functions - Microsoft Excel Tutorials

13.  Use the INT function with the IF function


To see if one value is a whole number and can be divided by another value, use the IF function in combination with the INT function.

To see if a whole number can be divided by 4:

1. Select cells B2:B10 and type the following formula: =IF(INT(A2/4)=A2/4,"whole number divisible by 4",FALSE).
2. Press <-Ctrl+Enter->.

Or

1. Select cells C2:C10 and type the following formula: =IF(A2/4-INT(A2/4)=0,"whole number divisible by 4", FALSE).
2. Press <-Ctrl+Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=9uIAT7uGFXQ

  Hope You Like This Tutorials - Give Comments