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
Cetakan
Benamkan

Papan mata

Kami sedang berusaha untuk menambah baik fungsi Papan Pendahulu. Sila bantu kami dengan memberikan maklum balas anda.

Beri Maklum Balas

Gaya visual

Pilihan

Kami kini sedang berusaha memperbaiki Tetapan Aktiviti. Sila bantu kami dengan memberikan maklum balas anda.

Beri Maklum Balas

Tukar templat

Pulihkan autosimpan: ?