AVERAGE, This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument., COUNT, This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range., SUM, This function adds all the values of the cells in the argument., MAX, This function determines the highest cell value included in the argument., MIN, This function determines the lowest cell value included in the argument., SUBTOTAL, This function returns the subtotal in a database., POWER, This function returns the result of a number raised to a certain power., CEILING, This function rounds a number up to its nearest multiple of significance., REPLACE, This function works on replacing the part of a text string with a different text string., SUBSTITUTE, This function replaces the existing text with a new text in a text string., NOW, This function in Excel gives the current system date and time., IF Formula, This function checks a given condition and returns a particular value if it is TRUE. It will return another value if the condition is FALSE..

TIC

oleh
Cetak
Menyematkan

Papan Peringkat

Gaya visual

Pilihan

Berganti templat

Pulihkan simpan otomatis: ?