EXCEL: What is ISEVEN function in excel, How to find if a number is EVEN in excel, Example ISEVEN👀
EXCEL: What is ISEVEN function in excel, How to find if a number is EVEN in excel, Example of ISEVEN👍 #excel #exceltricks #exceltutorialforbeginners #exceltips #exceltutorial #iseven #excelfunction #excelfunctions #excelformula #isevenfunction
If a given integer is even, the ISEVEN function in Excel returns TRUE; if it is odd, it returns FALSE. The ISEVEN function's syntax is as follows:
=ISEVEN(number)
The value you wish to check for evenness is number.
For instance, you could use the following formula to determine whether the value in cell A1 is even:
=ISEVEN(A1)
The formula will yield TRUE if value in A1 is even, and FALSE if value in A1 is odd.
Another instance:
Let's imagine you want to know which of the numbers in cells A1 through A5 is even. You have a list of numbers. To accomplish this, combine the IF function with the ISEVEN function.
Enter the expression =IF(ISEVEN(A1),"Even","Odd") in cell B1.
Cells B2 to B5 should be where you drop the formula.
Using the ISEVEN function, the IF function determines whether the integer in cell A1 is even. The function returns "Even" if the value is even, and "Odd" otherwise. The formula can be moved down to affect the other cells in the list using the same reasoning.
The column that displays whether each number in the list is even or odd should now be visible.
----------------------------------------------------------------------------------------------------------------
Here's another example:
Let's imagine you want to determine which of a column of integers in cells A1 to A10 is even. In cell B1, you may enter the following formula:
=ISEVEN(A1)
To apply this formula to the remaining cells in the column, move it down to cells B2 through B10. The outcome is a column of TRUE and FALSE values that represent the evenness or oddness of each number in column A.
You can then highlight the even numbers with conditional formatting. In order to achieve this, first pick the cells A1–A10, then click the "Home" tab, "Conditional Formatting," and then "New Rule." Select "Use a formula to determine which cells to format" in the dialogue box that displays, then type the following formula:
=ISEVEN(A1)
To apply the conditional formatting, click "OK" after selecting the formatting you wish to use for the even numbers by clicking the "Format" button. The formatting you selected will now highlight the even numbers in column A.
Now, according to your chosen formatting, the even numbers in column A will be highlighted.
________________________________________________________
Another example:
Let's imagine you want to add only the even numbers in a list of numbers in cells A1 through A10, not the other numbers. In order to do this, combine the ISEVEN function with the SUMIF function.
First, you can use the ISEVEN function to develop a formula in cell B1 that determines whether the number in A1 is even:
=ISEVEN(A1)
Then, in cell C1, enter the SUMIF formula to add just the even integers in the list:
=SUMIF(B1:B10,TRUE,A1:A10)
This formula adds up the corresponding values in the range A1:A10 and examines the range B1:B10 for values that are TRUE (i.e., even numbers).
You should receive the sum of all even integers in the list once you insert this formula in cell C1. You can modify the A1–A10 range to meet your own data set.
-----------------------------------------------------------------------------------------------------------
Here's another illustration:
Let's say you want to determine which numbers in a row, from cells A1 to F1, are even. When combined with the IF function, the ISEVEN function allows you to return one value for even integers and a different value for odd numbers.
For instance, you can enter the formula below into cell A2:
=IF(ISEVEN(A1),"Even","Odd")
To apply this formula to the remaining cells in the row, duplicate it to cells B2 through F2. The string "Even" will be returned by this formula for even numbers and "Odd" for odd numbers.
You can also use the SUMPRODUCT function to count the number of even numbers in the row. For example, you can use the following formula in cell A3:
=SUMPRODUCT(--ISEVEN(A1:F1))
This formula will count the number of even numbers in the range A1:F1, and return the result in cell A3. Note that the double negative (--) is used to convert the TRUE and FALSE values returned by ISEVEN to 1's and 0's, respectively, so that they can be summed by SUMPRODUCT.