=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

由
列印
嵌入

視覺風格

活動設定 排行榜 作業

活動設定

排行榜

切換範本

恢復自動保存: ?