ADDRESS function.Get cell addresses by specifying row and column numbers.(Microsoft Excel)
Japanese version.
Get cell addresses by specifying row and column numbers.
It is rarely used alone, but i ...
INDIRECT function.Specify a cell address as a string and get the value of that cell.(Microsoft Excel)
Japanese version.
Specify a cell address as a string and get the value of that cell.
By itself, this func ...
XOR function.Conditional judgment of exclusive OR.(Microsoft Excel)
Japanese version.
A companion to the AND and OR functions, it retrieves the exclusive OR.
XOR is TRUE onl ...
AND Specify logical OR and logical AND for the judgment condition.(Microsoft Excel)
Japanese version.
This function is used to specify logical OR and logical AND for IF function, IFS function, co ...
IFS function.Specify multiple conditions and get the value corresponding to the first matching condition.(Microsoft Excel)
Japanese version.
Specify multiple conditions and get the value corresponding to the first matching condition.
SWICTH function.Displays the first result matching the specified value.(Microsoft Excel)
Japanese version.
Displays the first result matching the specified value.
How it works=SWITCH(expression, va ...WEEKDAY function. Get the day of the week corresponding to the date.(Microsoft Excel)
Japanese version.
Get the day of the week corresponding to the date.
How it works=WEEKDAY(Serial_number,Valu ...CHOOSE function. Displays the corresponding value from 1 to 254.(Microsoft Excel)
Japanese version.
Displays the corresponding value from 1 to 254
How it works=CHOOSE(Index_num,Value1 to Val ...DSUM function. Total values by specifying aggregate items and search criteria.(Microsoft Excel)
Japanese version.
Total values by specifying aggregate items and search criteria.
What is a database in Exce ...DPRODUCT function. Get the result of multiplication by specifying the aggregate items and search conditions.(Microsoft Excel)
Japanese version.
Get the result of multiplication by specifying the aggregate items and search conditions. ...