Rumus Excel

SUM (Jumlah Nilai)

=sum(number1; [number2]; ...)

AVERAGE (Rata-rata)

=average(number1; [number2]; ...)

MEDIAN (Nilai Tengah)

=median(number1; [number2]; ...)

COUNT (Jumlah Data)

=count(value1; value2; ...)

LEFT

=left(text; [num_chars])

RIGHT

=right(text; [num_chars])

MODE

=mode(number1; [number2]; ...)

MAX (Maksimum)

=max(number1; [number2]; ...)

MIN (Minimum)

=min(number1; [number2]; ...

MID

=mid(text; start_num; num_chars)

IF (Logika)

=if(logical_test; [value_if_true]; [value_if_false])

umlah Nilai)

=sum(number1; [number2]; ...)

AVERAGE (Rata-rata)

=average(number1; [number2]; ...)

MEDIAN (Nilai Tengah)

=median(number1; [number2]; ...)

COUNT (Jumlah Data)

=count(value1; value2; ...)

LEFT

=left(text; [num_chars])

RIGHT

=right(text; [num_chars])

MODE

=mode(number1; [number2]; ...)

MAX (Maksimum)

=max(number1; [number2]; ...)

MIN (Minimum)

=min(number1; [number2]; ...

MID

=mid(text; start_num; num_chars)

IF (Logika)

=if(logical_test; [value_if_true]; [value_if_false])