=SUM() - Performs addition on a range of cells, =A1+A2 - Adds the values of the two cells together, =MIN() - Returns the minimum value of a range of cells, =MAX() - Returns the maximum value of a range of cells, =AVERAGE() - Calculates the average of selected cells, =COUNT() - Counts the total number of selected cells but it will not count the blank cells, =VLOOKUP() - Searches for the value in the leftmost column of the table array and returns the value from the same row from the specified columns, =IF() - If the logic in the formula is correct a value will be returned, if it is false then a different value is returned,

Excel Formulas

印刷
埋め込み

リーダーボード

表示スタイル

オプション

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

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