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. ...
DMIN function. Get the minimum value by specifying the aggregate items and search conditions.(Microsoft Excel)
Japanese version.
Get the minimum value by specifying the aggregate items and search conditions.
What is a d ...DMAX function. Get the maximum value by specifying the aggregate items and search conditions.(Microsoft Excel)
Japanese version.
Get the maximum value by specifying the aggregate items and search conditions.
What is a d ...DCOUNTA function. Get the number of non-blank cases by specifying the aggregate items and search criteria.(Microsoft Excel)
Japanese version.
This function obtains the number of non-blank counts by specifying items and conditions.
DCOUNT function. Get the number of numerical counts by specifying the aggregate items and search conditions.(Microsoft Excel)
Japanese version.
This function retrieves the number of numerical counts by specifying items and conditions.
DAVERAGE function. Get the average value by specifying the aggregation items and search conditions.(Microsoft Excel)
Japanese version.
A function that averages values given an item and a condition.
What is a database in Excel ...