INSTALL
लोकप्रिय
janani Prabakaran
778 ने देखा
•
26 दिन पहले
#basic computer
#computer basic
#computer basic
#basic computer 🖥
16
9
कमेंट
Your browser does not support JavaScript!
![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](https://cdn4.sharechat.com/bd5223f_s1w/compressed_gm_40_img_149881_3a4a0ca9_1774976148284_sc.jpg?tenant=sc&referrer=pwa-sharechat-service&f=284_sc.jpg "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")