USE THE INT FUNCTION WITH THE IF FUNCTION USING MICROSOFT EXCEL

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->.

USE THE INT FUNCTION WITH THE IF FUNCTION USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, IF Function in Excel, INT Function in Excel, Use the INT function with the IF function using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel