ISLOGICAL
Checks whether a value is the logical value TRUE or FALSE.
Syntax
=ISLOGICAL(value)
Example:
=ISLOGICAL(TRUE)
Result:
TRUE
ISEVEN
Checks whether a number is even.
Syntax
=ISEVEN(number)
Example:
=ISEVEN(24)
Result:
TRUE
=ISEVEN(25)
Result:
FALSE
ISODD
Checks whether a number is odd.
=ISODD(25)
Result:
TRUE
Practical Example
|
Number |
Even/Odd |
|
12 |
|
|
17 |
|
|
24 |
|
|
31 |
|
|
50 |
Formula:
=IF(ISEVEN(A2),”Even”,”Odd”)
Practice
Create a Student Roll Number Checker and classify roll numbers as Even or Odd.