Panduan Fungsi Excel

DAY(serial_number)

Penjumlahan dan pengurangan

YEAR(serial_number)

LARGE(array, k)

SUMIFS(sum_range, criteria_range1, criteria1, …)

IF(logical_test, value_if_true, value_if_false)

MOD(number, divisor)

DATE(year, month, day)

COUNTIF(range, criteria)

ROUND(number, num_digits)

SUMIF(range, criteria, [sum_range])

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

MONTH(serial_number)

INDEX(array, row_num, [column_num])

TODAY()

NOW()

WORKDAY(start_date, days, [holidays])

UPPER(text)

MOD(number, divisor)

SORT(array, [sort_index], [sort_order], [by_col])

XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])

SMALL(array, k)

TEXT(value, format_text)

AND(logical1, [logical2], …)

OR(logical1, [logical2], …)

EOMONTH(start_date, months)

TRIM(text)

MEDIAN(number1, [number2], …)

AVERAGEIF(range, criteria, [average_range])

SUMPRODUCT(array1, array2) / SUM(number1)

MIN(number1, [number2], …)

WEEKDAY(serial_number, [return_type])

SUM(number1, [number2], …)

LOWER(text) dan TRIM(text)

MATCH(lookup_value, lookup_array, [match_type])

SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)

RIGHT(text, [num_chars])

LEN(text)

ROUNDDOWN(number, num_digits)

DAYS(end_date, start_date)

ROUNDUP(number, num_digits)

FIND(find_text, within_text, [start_num])

IFERROR(value, value_if_error)

MAX(number1, [number2], …)

MID(text, start_num, num_chars)

Pengurangan: nilai_tagihan - pembayaran

FILTER(array, include, [if_empty])

AVERAGE(number1, [number2], …)

IF(logical_test, value_if_true, value_if_false)

SUM(number1, [number2], …)

SUMPRODUCT(array1, array2)

TEXTJOIN(delimiter, ignore_empty, text1, …)

SUBSTITUTE(text, old_text, new_text, [instance_num])

LOWER(text)

UNIQUE(array, [by_col], [exactly_once])

EDATE(start_date, months)

SUMPRODUCT(array1, [array2], …)

IF(logical_test, value_if_true, value_if_false) dan COUNTIF(range, criteria)

NETWORKDAYS(start_date, end_date, [holidays])

VALUE(text)

PROPER(text)

COUNTA(value1, [value2], …)

LEFT(text, [num_chars])

COUNTIF(range, criteria)

IF(logical_test, value_if_true, value_if_false)

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)

ISNUMBER(value)

COUNT(value1, [value2], …)

ABS(number)

CONCATENATE(text1, [text2], …)

REPLACE(old_text, start_num, num_chars, new_text)

SEARCH(find_text, within_text, [start_num])