ISEVEN
Formulas / ISEVENTest if a value is even.
ISEVEN(number)
- number - required argument to test
Examples
=ISEVEN(4)The ISEVEN function returns a logical value (TRUE or FALSE) based on the value of a given number. In this example, the number 4 is the argument given to the function. Since 4 is an even number, the function returns TRUE.
=ISEVEN(0)The same principle applies to the number 0. Since 0 is an even number, the function returns TRUE.
=ISEVEN(3)In this example, the number 3 is the argument given to the function. Since 3 is an odd number, the function returns FALSE.
Summary
The ISEVEN function is a useful tool for determining whether a number is even or odd. It returns TRUE if the number is even and FALSE if the number is odd.
- The ISEVEN function will check whether the value inserted is even or odd, returning either TRUE or FALSE.
- If the number inserted is even, then the ISEVEN function will return TRUE.
- If the number inserted is odd, then the ISEVEN function will return FALSE.
Need help with Formulas?
Frequently Asked Questions
What is the ISEVEN function?
The ISEVEN function is a logical function used in Sourcetable. It is used to test whether a number is even or odd.
How does the ISEVEN function work?
The ISEVEN function takes a number as an argument and returns the logical value TRUE if the number is even, or FALSE if the number is odd.
What types of numbers can be tested with the ISEVEN function?
The ISEVEN function only tests if the number is an integer. It cannot test decimal numbers, fractions, or other types of numbers.
What is the syntax for the ISEVEN function?
The syntax for the ISEVEN function is as follows:
- ISEVEN(number)
Can the ISEVEN function be used with cell references?
Yes, the ISEVEN function can be used with cell references. For example, if the number is stored in cell A1, the formula should be written as “ISEVEN(A1)â€.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV