Formulas and Functions

Select version:

Modifying this control will update this page automatically

Table of Contents

Welcome
Intro to formulas and functions
- DATE
- DATEDIF
- DATEVALUE
- DAY
- DAYNAME
- DAYS360
- EDATE
- EOMONTH
- HOUR
- MINUTE
- MONTH
- MONTHNAME
- NETWORKDAYS
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARFRAC
- BASETONUM
- BESSELJ
- BESSELY
- BIN2DEC
- BIN2HEX
- BIN2OCT
- CONVERT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- ERF
- ERFC
- GESTEP
- HEX2BIN
- HEX2DEC
- HEX2OCT
- NUMTOBASE
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
- AND
- FALSE
- IF
- IFERROR
- IFS
- ISBLANK
- ISDATE
- ISERROR
- ISEVEN
- ISNUMBER
- ISODD
- ISTEXT
- NOT
- OR
- TRUE
- ABS
- CEILING
- COMBIN
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FLOOR
- GCD
- INT
- LCM
- LN
- LOG
- LOG10
- MOD
- MROUND
- MULTINOMIAL
- ODD
- PI
- POLYNOMIAL
- POWER
- PRODUCT
- QUOTIENT
- RAND
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SERIESSUM
- SIGN
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TRUNC
- ADDRESS
- AREAS
- CHOOSE
- COLUMN
- COLUMNS
- FORMULATEXT
- HLOOKUP
- HYPERLINK
- INDEX
- INDIRECT
- INTERSECT.RANGES
- LOOKUP
- MATCH
- OFFSET
- REFERENCE.NAME
- ROW
- ROWS
- TRANSPOSE
- UNION.RANGES
- VLOOKUP
- XLOOKUP
- XMATCH
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- CHAR
- CLEAN
- CODE
- CONCATENATE
- COUNTMATCHES
- DOLLAR
- EXACT
- FIND
- FIXED
- LEFT
- LEN
- LOWER
- MID
- PLAINTEXT
- PROPER
- REGEX
- REGEX.EXTRACT
- REPLACE
- REPT
- RIGHT
- SEARCH
- SUBSTITUTE
- T
- TEXTAFTER
- TEXTBEFORE
- TEXTBETWEEN
- TRIM
- UPPER
- VALUE
- ACOS
- ACOSH
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- COS
- COSH
- DEGREES
- RADIANS
- SIN
- SINH
- TAN
- TANH

ISEVEN

The ISEVEN function returns the boolean value TRUE if the given number is even (leaves no remainder when divided by 2); otherwise it returns the boolean value FALSE.

ISEVEN(num)

num: A number value or boolean value. If num is the boolean value TRUE (value of 1), the function returns FALSE. If num is the boolean value FALSE (value of 0), the function returns TRUE.

Examples

=ISEVEN(2) returns TRUE.

=ISEVEN(2.75) returns TRUE. The decimal portion is ignored.

=ISEVEN(3) returns FALSE.

See alsoISODD

Helpful?