Basic math functions: abs, even, odd, iseven, isodd
Excel Function ABS
The ABS() function is used to return the absolute value of a number.
This function returns a positive value of the number.
This function can be used to convert a negative number to positive.
This function can be used with both integers and decimal numbers.
ABS()
Random number | Formula | Absolute Value |
11.1241790449763 | =ABS(L9) | 8.20474445795378 |
16.6185270585202 | =ABS(L10) | 4.26679100377716 |
-10.6432783782696 | =ABS(L11) | 7.81994186525427 |
-10.6916448497256 | =ABS(L12) | 5.3675672383259 |
-11.1335378056359 | =ABS(L13) | 10.2208767206977 |
5 | =ABS(L14) | 5 |
-82 | =ABS(L15) | 82 |
Excel Function EVEN
The EVEN() function rounds the number to the nearest even number.
The EVEN() function always rounds the number to the next highest even number.
If used with decimal numbers, it always returns the integer.
This function can be used to round the number to odd value also.
Random number | even number | odd numbers | odd numbers |
even(value) | even(value)-1 | odd(value) | |
4.1 | 6 | 5 | 5 |
7 | 8 | 9 | 7 |
97 | 98 | 99 | 97 |
11 | 12 | 13 | 11 |
187 | 188 | 189 | 187 |
186
From the above example, it is seen that, 4.1 is rounded to 6, though 4 is the nearest even number.
Excel Function ODD
The ODD() function returns the nearest odd number greater than the number specified.
The ODD() function is used when there is a need to determine the nearest odd value.
The ODD() function can also be used to determine the nearest even number by adding -1.
This function can also be used to determine the lower odd value by subtracting 2.
Random number | Odd number | Even number | Lower odd number |
ODD(value) | ODD(value)-1 | ODD(value)-2 | |
4.1 | 5 | 4 | 3 |
8 | 9 | 8 | 7 |
24 | 25 | 24 | 23 |
12 | 13 | 12 | 11 |
900 | 901 | 900 | 899 |
Excel Function ISEVEN
The ISEVEN() function is used to determine if the given number is even?
This function can be used with integers, floating numbers, positive and negative numbers.
When used with floating point numbers, this function takes only the real part into consideration.
The decimal part is ignored irrespective of even or odd.
Random number | ISEVEN | Formula |
4.1 | True | =ISEVEN(L54) |
7 | False | =ISEVEN(L55) |
5.2 | False | =ISEVEN(L56) |
-2 | True | =ISEVEN(L57) |
900 | True | =ISEVEN(L58) |
Excel Function ISODD
The ISODD() function is used to determine if the given number is odd?
This function can also be used with both positive and negative integers and decimal numbers.
In case of decimal numbers, only the real part is considered.
Random number | ISODD | Formula |
4.1 | False | =ISODD(L69) |
7 | True | =ISODD(L70) |
5.2 | True | =ISODD(L71) |
-2 | False | =ISODD(L72) |
900 | False | =ISODD(L73) |