
- 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))