Create IF statements with AND/ OR arguments
In the simplest terms, IF statements are logic based formula which tests a condition and returns one value for a true statement and another for a false statement.
How to use INDEX and MATCH
The index and match formula is an advanced lookup which has many advantages over vlookups. It gives users the flexibility to combine horizontal and vertical matches as well as lookup multiple column or row criteria.
Rounding numbers to a specified decimal place or nearest major unit
Sometimes you don’t require numbers to the nth level of detail, especially if you want to avoid Excel’s ###### symbol or having to resize your columns
Return a result from a corresponding column in a table with VLOOKUP
A vlookup is a vertical lookup between two corresponding columns in a data table, where the value returned is based on the first match.