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)

 

You can find similar Excel Questions and Answer hereunder

1) Various important math functions in VBA (trigonometry, algebra, exponential, �)

2) Is there a way I can round the sales figure to the nearest 500?

3) basic math functions ceiling combin exp fact floor

4) basic math functions round rounddown roundup sign

5) basic math functions sin cos tan csc sec cot

6) basic math functions hyperbolic functions sinh cosh tanh csch sech coth

7) basic math functions log log10 roman trunc

8) basic math functions power product quotient mod sum

9) basic math functions seriessum sumsq sumx2my2 sumx2py2 sumxmy2 subtotal

10) basic math functions asin acos atan acot

 

Here the previous and next chapter