Math & Trig(Microsoft Excel Functions)

Japanese version. It includes functions and trigonometric functions, primarily for calculating. Functions. Functions to aggregate multiple values or cells Function Importance Description SUM High Get the sum of the numbers. SUMIF Low Sum the values of cells matching the search criteria. SUMIFS High Sum the values of cells matching multiple criteria. SUMPRODUCT Low Add and multiply together. SUMSQ Low Get the sum of squared values. PRODUCT Low Perform multiplication. SUBTOTAL Low Aggregate only the values displayed. Functions to manipulate values Function Importance Description ABS Middle Get absolute value. SIGN Middle Get Signs. ARABIC Low Convert Roman numerals to Arithmetic (Indian and Arabic) numerals. ROMAN Low Converts numbers (arithmetic and Indian/Arabic) … Continue reading Math & Trig(Microsoft Excel Functions)