ISEVEN function - Function returns True value if the value is even in Excel
The following article introduces you to the ISEVEN function - one of the functions in the information function group is very popular in Excel.
Description: The function returns True if the value is even in Excel.
Syntax: ISEVEN (value)
Inside:
- value: The value you want to determine is even or not, is a required parameter.
Attention:
- The function returns True if the value is even and vice versa if an odd number the function returns False.
- If Value is not a numeric value -> the function returns the #VALUE! Error value
- If value value is blank -> the function considers that value as 0.
For example:
Determine whether the values in the value are even.
- In the cell to calculate enter the formula : = ISEVEN (C6)
- Press Enter -> return value is:
- Where value is blank -> the function considers it as a value of 0:
- Where the value is not numeric -> the function returns the error value #VALUE!
Above are instructions and some specific examples when using ISEVEN function in Excel.
Good luck!
You should read it
- How to use the IFS function in Excel 2016
- ISODD function - The function returns True if the value is an odd number in Excel
- ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel
- ISNONTEXT function - The function returns True if the value is not a text value in Excel
- ISTEXT function - Function returns True value if that value is text in Excel
- ISREF function - The function returns True if the value is a valid reference value in Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- Any () function in Python
May be interested
- ISNA function - The function returns True if the value is an # N / A error value in Excelisna function: the function returns true if the value is an # n / a error value in excel. syntax: isna (value)
- ISERROR function - The function returns True if the value is any error in Exceliserror function: the function returns true if the value is any error in excel. syntax: iserror (value)
- ISLOGICAL function - The function returns True if the value is a logical value in Excelislogical function: the function returns true if that value is a logical value in excel. syntax: islogical (value)
- CHISQ.TEST function - The function returns the independence test in Excelchisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- ISERR function - Function returns True if the value is any error except # N / A error in Exceliserr function: the function returns true if the value is any error except # n / a error syntax: iserr (value)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- Any () function in Pythonin python, any () function returns true if any element of an iterable is true. if no true element is present, any () function will return false.
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.