ODDCOUNTBETWEEN

Counts the number of odd numbers between two numbers.

Syntax

ODDCOUNTBETWEEN(number1, number2)

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

Remark

0 is not considered by the ODDCOUNTBETWEEN funciton as an odd number.

Example

ODDCOUNTBETWEEN(0, 13) returns 7
ODDCOUNTBETWEEN (13, 0) returns 7
ODDCOUNTBETWEEN (-1234.76,13656.88) returns 7445.