
 Sum, Count, Average
=SUM(A1:A10)
Count
=Count(A1:A10)
Average
=Average( Value1, Value2)
 If statements
=IF(A1>A2, “GOOD”, “BAD”)
 Sumif, Countif, Averageif
=SUM(A1:A15, “GOOD”, B1:B13)
=Countif(Range, Criteria, Function range)
=averageif( Range, Criteria, Function range )
 VLookup
=VLOOKUP(lookup value, the table being searched, index number, sorting identifier)
 Concatenate
=CONCATENATE(A1,” “,B2)
 Max and Min
=MAX(A1:A10)
Min =MIN(A1:A10)
 And
=AND(A1=“GOOD”, B2>10)
 Proper
=PROPER(A1)
 Conditional Formatting
No Formula for this but you can select: Home –> Styles –> Conditional formatting, you can select many options that will give outputs if certain things are true. You can do a lot of this with the formulas mentioned before, but why not let Excel do the hard work.
 Index + match
=INDEX(list of values, MATCH(what you want to lookup, lookup column, sorting identifier))