Group Numbers in Excel and IFS and FormulaText functions

Group Numbers in Excel and IFS and FormulaText functions

Two new Excel 2016 Functions

IFS - The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements and is much easier to read with multiple conditions. FormulaText - The FORMULATEXT function returns what is displayed in the formula bar if you select the referenced cell.

Example of IFS And FormulaText

IFS and FormulatText - sample Excel file for downloading.

Chris Menard

Chris trains corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. When he's not training, he blogs about technology and creates training videos on YouTube. Chris currently has over 240 technology videos available, most of which have been created following questions asked during Microsoft Office training sessions.

Categories