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 on Linkedinchris menard on Youtube
chris menard
Microsoft Office Master Instructor
I train corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. When I'm not training, I blog about technology and create training videos on YouTube. I currently have over 240 technology videos available. Most of the videos I've created come from questions asked during MS Office training.

Pin It on Pinterest