ISODD function - The function returns True if the value is an odd number in Excel
The following article introduces you to the ISODD function - one of the functions in the information function group is very popular in Excel.
Description: The function returns True if the value is odd. Application of functions to check odd and even numbers.
Syntax: ISODD (number)
Inside:
- number: The value to check is an odd number or not, is a required parameter.
Attention:
- The function returns True value if that value is an odd number and vice versa, the function returns False value .
- Where value is blank -> the function considers it as a value 0 -> returns False.
- Where the value is not a numeric value -> the function returns the #VALUE! Error value
For example:
Determine whether the values in the value are odd or not.
- In the cell to calculate enter the formula : = ISODD (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- Where value is blank -> function returns False value :
- Where the value is not a numeric value -> the function returns the #VALUE! Error value
Above are instructions and some specific examples when using ISODD function in Excel.
Good luck!
You should read it
- How to use the IFS function in Excel 2016
- COUPNUM function - The function returns the number of interest payments on a security in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- PERMUT function - The function returns the number of permutations of a given number of objects in Excel
- The DAYS function - The function returns the number of days between 2 dates in Excel
- GAMMA function - The function returns the gamma function value in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel
May be interested
- PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excelpermutationa function: the function returns the number of permutations (can be repeated) of a given object. support functions from excel 2013 onwards. syntax: permutationa (number, number_chosen)
- 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)
- 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)
- ISREF function - The function returns True if the value is a valid reference value in Excelisref function: the function returns true if that value is a valid reference value. application function to check if the value is a reference value or not. syntax: isref (value)
- RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excelrank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
- SHEETS function - The function returns the number of pages in a reference in Excelsheets function: the function returns the number of pages in a reference. support functions from excel 2013 onwards. syntax: sheets (reference)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- The SQRT function returns the square root of a positive number in Excelthe sqrt () function in excel helps you quickly calculate the square root of any number you want. the syntax and usage of the function is very simple, but if you do not know, follow the article below.
- ISNUMBER function - The function returns True if the value is numeric in Excelisnumber function: the function returns true if the value is numeric. use the function to check if the value is numeric or not. syntax: isnumber (value)
- How to use ADDRESS function in Excelthe address function in excel takes the number of rows and column numbers as arguments and returns the reference of the standard cell (cell address). for example, if you go to row 4 and column 3, the function returns c4.