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

Use IFS function to calculate letter grades in Excel Added by Microsoft in 2016, the IFS function replaces the need for multiple nested IF statements. You can put all your conditions (percentage grade ...