ShareChat
click to see wallet page
search
#basic computer #computer basic #computer basic #basic computer 🖥
basic computer - SUM AVERAGE 5 Calculates the Adds values average of values  SUM(A1:A5) =AVERAGE(B1:B1) COUNTA COUNT 5 Counts the number Counts the number of non-empty cells of cells with numbers =COUNT(A1:A10) COUNTA(A1:A10) MAX MIN Returns the largest Returns the smallest value value =MAX( B1:B10) =MTN (B1:B10) VLOOKUP IF Performs a logical Looks up a value test and returns a in a table value =VLOOKUP('Product' TF (41>10, 'Yes' 'No' A1:B19,2, FALSE) CONCAT TRIM ] Removes extra Combines text from multiple cells spaces from text SUM AVERAGE 5 Calculates the Adds values average of values  SUM(A1:A5) =AVERAGE(B1:B1) COUNTA COUNT 5 Counts the number Counts the number of non-empty cells of cells with numbers =COUNT(A1:A10) COUNTA(A1:A10) MAX MIN Returns the largest Returns the smallest value value =MAX( B1:B10) =MTN (B1:B10) VLOOKUP IF Performs a logical Looks up a value test and returns a in a table value =VLOOKUP('Product' TF (41>10, 'Yes' 'No' A1:B19,2, FALSE) CONCAT TRIM ] Removes extra Combines text from multiple cells spaces from text - ShareChat