SUMPRODUCT function. Add and multiply together.(Microsoft Excel)
Japanese version.
Add and multiply together.
How it works=SUMPRODUCT(array1 to 255)NameOmissionSpecifyarray1 ...SUMSQ function. Get the sum of squared values.(Microsoft Excel)
Japanese version.
SUMSQ function. Get the sum of squared values.
How it works=SUMSQ(Number1 to 255)NameOmiss ...SUBTOTAL function. Aggregate only the values displayed.(Microsoft Excel)
Japanese version.
Aggregate only the values displayed.
Aggregate functions, such as the SUM function, inc ...
PRODUCT function. Perform multiplication.(Microsoft Excel)
Japanese version.
The PRODUCT function is a companion to the SUM function.
While the SUM function adds, t ...
ABS function. Get absolute value. SIGN function. Get Signs.(Microsoft Excel)
Japanese version.
The ABS function can be used to get a number without a positive or negative sign.
The S ...
QUOTIENT function. Get the integer part of the result of division.(Microsoft Excel)
Japanese version.
Get the integer part of the result of division.
How it works=QUOTIENT(Numerator,Denominato ...POWER function. Performs a power of power calculation.(Microsoft Excel)
Japanese version.
Performs a power of power calculation.
How it works=POWER(Number,Power)NameOmissionSpecify ...RAND function. Randomly obtains a small number greater than or equal to 0 and less than 1.(Microsoft Excel)
Japanese version.
Randomly obtains a small number greater than or equal to 0 and less than 1.
However, fo ...
LARGE and SMALL functions. Get the number corresponding to the rank.(Microsoft Excel)
Japanese version.
Get the number corresponding to the rank.
It works in reverse of the RANK function. ...
RANK function. Get the rank in the range.(Microsoft Excel)
Japanese version.
Get the rank in the range.
The RANK function has two functions that differ in their tre ...