Which function would you use if you needed to test multiple conditions within an IF statement in Excel and return TRUE only if all conditions are met?

AND

OR

SUMIFS

AVERAGEIFS