=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

由
打印
嵌入

排行榜

视觉风格

选项

切换模板

)
恢复自动保存：？