Microsoft Excel is the best and most widely used spreadsheet software worldwide. It can be quite daunting to use if you don't know which formulas and functions to use for specific purposes. Here is a list of all Microsoft Excel formulae sorted by their functions.
The most important and most used mathematical functions are addition, subtraction, division and multiplication so here are the formulas for each of them in Microsoft Excel.
SUMPRODUCT: Multiplies and sums up corresponding items in an array.
SUBTOTAL: Is used to find the subtotal of numbers in a column, list or database.
There is no specific formula for subtraction in Excel, to subtract numbers in a cell, you can use the minus sign on your keyboard for example (=20 – 10) or (=A5 – C3) and the cell will return the difference automatically.
To subtract numbers in a range, you have to use the SUM formula by making the numbers you want to subtract negative and then adding all the numbers in the range.
SUMPRODUCT: see addition formulas for usage.
MMULT: used for multiplying two arrays in a matrix.
DPRODUCT: Used to multiply database values based on given criteria.
Division in MS Excel can be done easily by using the forward slash operator for example (=20/4) or (=F9/E7). There are no other functions for division in Excel.
AGGREGATE: used to apply formulas like AVERAGE, SUM, MAX while ignoring errors and hidden rows.
EVEN: Is used to round up numbers to the closest even integer.
RANDBETWEEN: Is used to find random numbers between a top and bottom range of numbers.
BINOM.INV: Used to find the smallest value when the cumulative binomial distribution is larger.
FORMAT NUMBERS: Is used to convert numeric expressions to formatted strings in VBA.
RANDOMIZE: Changes seed value used by the random number generator for RND function in VBA.
STRCONV: Is used to convert a string to uppercase, lowercase, sentence case or Unicode.