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)