Excel can be used very efficiently to perform arithmetic functions in excel. The basic maths function in excel are very handy for a financial analyst who performs data analysis, calculates SUM or Average, Max or Min etc.
Top maths functions in excel discussed here are as follows -
SUM and SUMIF function
ODD and EVEN Functions in excel
SUMPRODUCT and SUMTOTAL function on excel
LOG and LN function
Exponential maths function in excel
Absolute function in excel
TAN function in excel
ABS Excel Function (Absolute)
ABS in Excel gives the absolute value of a number. It always returns a positive number.
ODD Function can be used round a number up to nearest odd integer and it will round the number up away from zero so if you round the positive numbers becomes larger and negative numbers become smaller.