Excel - Logical and conditional functions

It is a logical function WHEN including its nested variant. Users with Microsoft Office 2019 and 365 licenses can use the new IFS function, which we will introduce you to, instead of nesting the WHEN function. Other logical functions include the logical relation A, OR. Conditional sums, numbers, averages are most elegantly solved by the function SUMIFS, COUNTIFS, AVERAGEIFS. And new MAXIFS and MINIFS features are available for Microsoft Office 2019 and 365 license users.

Basic knowledge of PC and Excel.

To all Excel users.

Logic functions

• WHEN - IF including nesting
• IFS
• A - AND
• OR - OR

Conditional functions

• SUMIF and SUMIFS
• COUNTIF and COUNTIFS
• AVERAGEIF - AVERAGEIFS
• MAXIFS
• MINIFS

• Know Logical Functions
• Know Conditional Functions