ShareChat
click to see wallet page
search
#🚹உளவியல் சிந்தனை #🛍 Shop
🚹உளவியல் சிந்தனை - Function Name Example SUM =SUM(A1:A1O) AVERAGE =AVERAGE(B1:B20) COUNT Screenshot it =COUNT(C1:C5O) COUNTA =COUNTAD:D) Must Know MAX =MAX(E1:E100) MIN =MIN(F1:F1OO) IF =|F(G1>10, High", "Low") SUMIF =SUMIF(H1:H10, ">50", |1:|10) COUNTIF =COUNTIF(J1:J2O, "Complete") VLOOKUP =VLOOKUP( Apple", A1:C1OO, 2, FALSE) HLOOKUP =HLOOKUP("Product ID", A1:Z10, 5, FALSE) INDEX =INDEX(A1:D10, 3, २) MATCH =MATCH(  Orange A1:A10, 0) =CONCATENATE(L1, M1) or =L1 & " CONCATENATE & M1 LEFT =LEFT("Excel", 3) RIGHT =RIGHT( "Spreadsheet", 5) MID =MID("Microsoft" 6, 3) LEN =LEN("Hello World") TODAY =TODAY() NOW =NOW( Function Name Example SUM =SUM(A1:A1O) AVERAGE =AVERAGE(B1:B20) COUNT Screenshot it =COUNT(C1:C5O) COUNTA =COUNTAD:D) Must Know MAX =MAX(E1:E100) MIN =MIN(F1:F1OO) IF =|F(G1>10, High", "Low") SUMIF =SUMIF(H1:H10, ">50", |1:|10) COUNTIF =COUNTIF(J1:J2O, "Complete") VLOOKUP =VLOOKUP( Apple", A1:C1OO, 2, FALSE) HLOOKUP =HLOOKUP("Product ID", A1:Z10, 5, FALSE) INDEX =INDEX(A1:D10, 3, २) MATCH =MATCH(  Orange A1:A10, 0) =CONCATENATE(L1, M1) or =L1 & " CONCATENATE & M1 LEFT =LEFT("Excel", 3) RIGHT =RIGHT( "Spreadsheet", 5) MID =MID("Microsoft" 6, 3) LEN =LEN("Hello World") TODAY =TODAY() NOW =NOW( - ShareChat