EVENCOUNTBETWEEN

Counts the number of even numbers between two numbers.

Syntax

EVENCOUNTBETWEEN(number1, number2)

number1, number2 are the two numbers between which the number of even numbers will be counted. Can be any number, even non-whole numbers.

Remark

0 is considered by the EVENCOUNTBETWEEN funciton as an even number.

Example

EVENCOUNTBETWEEN(0, 13) returns 7
EVENCOUNTBETWEEN(13, 0) returns 7
EVENCOUNTBETWEEN (-1234.76,13656.88) returns 7446.