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 is a Microsoft Office Master Instructor. He trains corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. Menard is a speaker for the Georgia Society of CPAs and the University of Georgia. When he's not training, he blogs about technology and creates training videos on YouTube. Currently, there are over 400 technology videos available on his YouTube Channel.

Categories