SUBSTITUTE function. Substitutes the specified text.(Microsoft Excel)
Japanese version. The SUBSTITUTE function sea ...
IF function.Change the result of the formula according to the results of the comparison.(Microsoft Excel)
Japanese version. The IF function is a functi ...
LEFT, MID, and RIGHT functions. Extracts strings by specifying the number of characters.(Microsoft Excel)
Japanese version. The LEFT, MID, and RIGHT fu ...
MOD function. Surplus.(Microsoft Excel)
Japanese version. If you perform division wit ...
MAKEARRAY Function. Create a range of cells and set formulas for individual cells.(Microsoft Excel)
The MAKEARRAY function is a new function adde ...
LEN function. Length of a character string.(Microsoft Excel)
Includes usage of the LEN function and exampl ...
SORT Function. Sort range of cells.(Microsoft Excel)
Includes how to use the SORT function, exampl ...
REDUCE Function. Cumulative calculation of a cell range.(Microsoft Excel)
Includes usage of the REDUCE function and exa ...
MAP function. Decompose cell range and retrieve individual cells.(Microsoft Excel)
Includes usage of the MAP function and exampl ...
RANDARRAY function. Random numbers in multiple cells.(Microsoft Excel)
Includes how to use the RANDARRAY function, e ...