IF with AND and IF with OR

The powerful function If can already do a lot of tricks, but we can for sure do more when we use it with AND or OR functions. Also, once we …

New function IFERROR, finally

We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore We can use the new …

OFFSET+MATCH

One of the power of combining functions in one cell is using the best of these functions An example is here, OFFSET + MATCH will allow you to do something …