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