Excel

Formula for matches

=IF(A1=B1, "Match", "No Match")

=IF(A1=B1, "Sama", "Beda")

Formula for difference

=ABS(A1-B1)

=IF(A1<>B1, "No Match", "Match")

Formula for sum

=SUM(A1:A10)

Formula for average

=AVERAGE(A1:A10)

Formula for count

=COUNT(A1:A10)

Formula for maximum

=MAX(A1:A10)

Formula for minimum

=MIN(A1:A10)

View

Excel-View-Freeze-panes-freese top