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

Excel Functions

oleh
Cetak
Menyematkan

Papan Peringkat

Gaya visual

Pilihan

Berganti templat

Pulihkan simpan otomatis: ?