max_range and min_range are the actual ranges in which the maximum or minimum value is determined.MINIFS(min_range, criteria_range1, criteria1,. Syntax MAXIFS(max_range, criteria_range1, criteria1,. MAXIFS and MINIFS return the maximum and minimum values respectively based on given conditions.Īs the name describes, MAXIFS identifies the maximum value based on multiple conditions given in the formula and MINIFS returns the MIN value based on multiple conditions.īoth the functions support logical operators and criteria based on numeric, text or dates.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |