Mathematical Formulas in Excel are used to perform various arithmetic operations like sum average count max min etc. Learn basic math functions including SUM ROUND and SUBTOTAL. The PRODUCT function - Multiplies two or more numbers together.
Use this function when you need to look in a single row or column and find a value from the same position in a second row or column.
Equals sign signals the start of a function Function name a unique identifier which tells Excel which set of formulas you would like to use. Use this function when you need to find things in a table or a range by row. All the mathematical functions in excel are categorized under the Math Trigonometry function in excel. These are Abs Atn Cos Exp Fix FormatNumber FormatCurrency FormatPercent Int Log Randomize Rnd Round Sgn Sin Sqr Tan etc.