Microsoft Excel is incredibly versatile, but there are a lot of functions you might not even know about. These are some of the best ones.

IF is one of the most widely used logical functions in Excel. It tests a condition and evaluates to either TRUE or FALSE. An IF formula has two possible outputs, one when the condition is TRUE and ...