Math & Trig(Microsoft Excel Functions)

01/09/202306/10/2023

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) to Roman numerals.
CEILING	High	Round up in multiples of the specified value.
FLOOR	High	Rounded down by multiples of the specified value.
INT	High	Convert decimals to integers.
TRUNC	High	Truncate a number to the specified number of digits or less.
GCD	Middle	Get the greatest common divisor.
LCM	Middle	Get the least common multiple.
MOD	Middle	Get the remainder of the result of division.
QUOTIENT	Middle	Get the integer part of the result of division.
POWER	Low	Performs a power of power calculation.
RAND	Middle	Randomly obtains a small number greater than or equal to 0 and less than 1.
RANDBETWEEN	Middle	Get a random number within the specified range.
RANDARRAY	Middle	Get a random number of cells in a specified range.
ROUND ROUNDUP ROUNDDOWN	High	Rounding/rounding up/down of numbers.

Spill Fanctions.

Function	Importance	Description
SEQUENCE	Middle	Create sequential numbers in multiple cells.