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