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

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time.