=SUM(range), Adds together a range of numbers., =AVERAGE(range), Finds the mean average of a range of numbers., =IF(condition, value_if_true, value_if_false), Tests a condition and returns one value if true and another if false., =VLOOKUP(lookup_value, table_range, column_number, exact/approx), Looks for a value in the first column of a table and returns information from another column in the same row., =MAX(range), Finds the largest number in a range., =MIN(range), Finds the smallest number in a range., =COUNT(range), Counts how many cells in a range contain numbers., =COUNTA(range), Counts how many cells in a range are not empty., =COUNTIF(range, condition), Counts how many cells in a range meet a condition., =LEN(cell), Counts the number of characters in a cell, including letters, numbers, spaces and punctuation., =PRODUCT(range), Multiplies numbers together..

Excel Functions

さんの投稿です
印刷
埋め込み

リーダーボード

表示スタイル

オプション

テンプレートを切り替える

)
自動保存: を復元しますか?