A list of common Excel Formulas

   06/09/2023  Posted in Tech 1 Likes 290 Views 

=SUM(A1:A10)
 =AVERAGE(B1:B20)
 =COUNT(C1:C100)
 =MAX(D1:D50)
 =MIN(E1:E30)
 =IF(F1>50, "Pass", "Fail")
 =VLOOKUP(G1, A1:B100, 2, FALSE)
 =HLOOKUP(G1, A1:D10, 3, FALSE)
 =INDEX(B1:B100, MATCH(G1, A1:A100, 0))
 =CONCATENATE (or &) / CONCAT: Combines multiple text strings into one.
Author: Web Admin
my sites Visit BikesVibes.com Visit Magic Cleaning Services Visit Rx7 Shee for all RX 7 parts
Website