=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

oleh
Cetakan
Benamkan

Papan mata

Gaya visual

Pilihan

Tukar templat

)
Pulihkan autosimpan: ?