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.

Applies To. The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria. Note: This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription.