Mathematical Formulas in Excel are used to perform various arithmetic operations like sum average count max min etc. Arithmetic in Excel 1. The Excel Math Functions perform many of the common mathematical calculations including basic arithmetic conditional sums products exponents logarithms and the trigonometric ratios.
SUBTOTAL - Returns a subtotal of a filtered list or database TRUNC - Truncates a number to an integer.
Int MS Excel Formula. Arithmetic in Excel 1. Mod MS Excel Formula. SUM helps users perform a quick summation of specified cells in MS Excel.