SEQUENCE function. Create sequential numbers in multiple cells.
Create sequential numbers in multiple cells.
TRUNC function. Truncate a number to the specified number of digits or less.(Microsoft Excel)
The TRUNC function truncates a number less than a specified digit.
INT function. Convert decimals to integers.(Microsoft Excel)
The INT function converts a small number to an integer.
CEILING and FLOOR functions.Round up/down by multiples of specified value(Microsoft Excel)
The CEILING and FLOOR functions can be used to round up or down The CEILING and FLOOR functions can be used to round ...
SUMIFS function. Sum the values of cells matching multiple criteria.(Microsoft Excel)
The SUMIFS function displays the sum of cells that satisfy multiple conditions.
It is a higher version of the S ...
ROUND, ROUNDUP and ROUNDDOWN functions.Rounding of numbers and rounding up and down.(Microsoft Excel)
ROUND series functions round numbers to the specified number of digits.
GCD function. The greatest common divisor.(Microsoft Excel)
Function to get the greatest common divisor given multiple numbers.
How it works=GCD(number1 to 255)NameOmissionEx ...LCM Function.Least common multiple.(Microsoft Excel)
Japanese version.
Function to get the least common multiple given multiple numbers.
How it works=LCM(number1 ...RANDBETWEEN function. Obtains a random number within the specified range.
Introduces the use of the RANDBETWEEN function.
SUMIF function. Sum the values of cells matching the criteria.(Microsoft Excel)
Japanese version
Extended version of the SUM function to obtain the sum of cells matching a criteria.
The ...