CODE Function. Get the numeric code of a character.(Microsoft Excel)
What is displayed as a character is also treated internally by the computer as a number.
The CODE function retr ...
CHAR Function. Get the character corresponding to a numeric code.(Microsoft Excel)
What is displayed as a character is also treated internally by the computer as a number.
TEXTJOIN function. Concatenates strings by specifying a delimiter.(Microsoft Excel)
The TEXTJOIN function creates a concatenated string by specifying specific characters.
It is very effective whe ...
ARRAYTOTEXT Function. Convert an array (cell range) to text.
Japanese version.
Function to convert an array (cell range) to text. Currently, this function is of little use. ...
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.
NUMBERVALUE function.Converts strings of numeric notation (decimal points and commas) from various linguistic regions to numerical values.
Functions for converting strings of numbers expressed in different formats to numeric values.