Maths Function in Excel
Excel Functions Tutorials
- Maths Functions in Excel
- POWER Function in Excel
- EVEN Function in Excel
- ODD Function in Excel
- ABS Function in Excel
- SUM Function in Excel
- SUMPRODUCT Function in Excel
- SUBTOTAL Excel Function
- ROUND in Excel
- AGGREGATE Excel Function
- PRODUCT Excel Function
- RAND Excel Function
- LOG Excel Function
- EXPONENTIAL Excel Function
- SUMIF in Excel
- TAN Excel Function
- CEILING Excel Function
- LN Excel Function
- SIGN Excel Function
- COS Excel Function
- FLOOR Function in Excel
- SIN Excel Function
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- DSUM
- COMBIN Excel Function
- INT Excel Function (Integer)
- TANH in Excel
List of Maths Function in Excel
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
POWER Function in Excel
Power in Excel is a Math function in excel that computes and returns the result of a number raised to a power.
EVEN Function in Excel
EVEN is a Math function in excel and is used to round up a number to its nearest even integer.
ODD Function in Excel
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.
ABS Function in Excel
ABS in Excel gives the absolute value of a number. It always returns a positive number.
SUM Function in Excel
SUM in Excel is a built-in function which adds all the numbers in the range of cells and returns the result of the addition.
SUMPRODUCT Function in Excel
SUMPRODUCT in Excel is used to calculate the sum of the products of corresponding numbers in one or more ranges/arrays.
SUBTOTAL Excel Function
SUBTOTAL function is a function which is responsible for returning the SUBTOTAL or the aggregate result of all the numbers which are present in a column of a list of particular database.
ROUND in Excel
Microsoft Excel ROUND Function is a Math/Trig Function, which is used to return a number rounded to a specific number of digits.
AGGREGATE Excel Function
AGGREGATE in excel is categorized as Math/Trig Function was introduced in Excel 2010 and it performs specified operation and returns an AGGREGATE in a list or database.
PRODUCT Excel Function
Product function in excel takes the arguments (input as numbers) and gives the product (multiplication) as an output.
RAND Excel Function
RAND function is categoried as Math function in excel returns a random number excel between 0 and 1.
LOG Excel Function
LOG function in Excel computes the logarithm of a number to the base that we specify.
EXPONENTIAL Excel Function
Exponential excel function called EXP function which is categorized as Math/Trig Function that returns a numeric value which is equal to e raised to the power of a given number.
SUMIF in Excel
SUMIF in Excel that adds all numbers in a range of cells that meet the specified criteria.
TAN Excel Function
TAN Excel Function is an inbuilt function categorized as Math/Trig function which returns the Tangent of an angle. Formula for TAN always returns a numeric value.
CEILING Excel Function
CEILING function is categories as Math or Trig function in excel returns a number rounded up based on a multiple of significance.
LN Excel Function
It is a built-in function in MS Excel. LN excel is categorized under Math Functions in MS Excel. Excel LN is used to calculate the natural logarithm of a number.
SIGN Excel Function
The SIGN function is a built-in function in Excel and is mostly used in association with other Excel functions.
COS Excel Function
The COS can be used in Excel Worksheet as a Worksheet (WS) function as well as in Excel VBA.
FLOOR Function in Excel
FLOOR in Excel is a Math/ Trig Function that rounds a number (towards zero) to the nearest specified multiple of significance.
SIN Excel Function
SIN function in Excel computes the Sine of an angle that we specify. It always returns a numeric value.