Excel
ISEVEN function in Excel
Returns TRUE if the number is even
=ISEVEN(number)ISEVEN syntax and parameters
One argument, one required.
- numbernumberRequired
The value to test. If number is not an integer, it is truncated.
ISEVEN examples
Formulas you'll actually reuse.
Is the row's ID number even?
=ISEVEN(B2)Result
TRUETotal for the even-numbered orders only:
=SUMPRODUCT(--ISEVEN(B2:B200), C2:C200)Result
74100
ISEVEN in Google Sheets
Same name — your formula ports as-is.
Try ISEVEN in the playground
Edit the example — nothing to install.
Preloaded with the ISEVEN formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- CELLReturns information about the formatting, location, or contents of a cellThis function is not available in Excel for the web.InfoGoogle Sheets
- ERROR.TYPEReturns a number corresponding to an error typeInfoGoogle Sheets
- INFOReturns information about the current operating environmentThis function is not available in Excel for the web.InfoNo Google Sheets equivalent
- ISBLANKReturns TRUE if the value is blankInfoGoogle Sheets
- ISERRReturns TRUE if the value is any error value except #N/AInfoGoogle Sheets
- ISERRORReturns TRUE if the value is any error valueInfoGoogle Sheets