What's New in Excel 2019 (Part 4 of 8): IFS, MAXIFS, and MINIFS
Interactive

What's New in Excel 2019 (Part 4 of 8): IFS, MAXIFS, and MINIFS

BizLibrary
Updated Feb 19, 2019
Book a demoTry it for free
An easy replacement for nested IF statements, MAXIFS and MINIFS let you return the maximum or minimum value in a selected range - this lesson reviews both functions.
Related learning
Excel 2013 Part 2: Use the MIN FunctionInteractive ⋅ 4 mins
Excel 2013 Part 2: Use the MAX FunctionInteractive ⋅ 3 mins
Excel 2013 Part 3: Perform a What-If AnalysisInteractive ⋅ 3 mins
MS Excel 2019 - Min and Max FunctionsInteractive ⋅ 5 mins

Explore more technology skills

IT Software
IT Software
Web Design and Development
Web Design and Development
Data & Analytics
Data & Analytics
Design and Animation
Design and Animation
Gaming and Games Development
Gaming and Games Development
Devops, Networking and Security
Devops, Networking and Security
Programming and Web Development
Programming and Web Development
Computer Science and Engineering
Computer Science and Engineering
;