Excel functions containing 'IF'

Can you name all Excel functions that contain 'IF'? They are listed in alphabetical order

List from here

Quiz by scambigol

Rate:

see leaders

Last updated: March 30, 2015

More quiz info >>

First submitted	March 30, 2015
Times taken	40

Quiz and answer stats >>

4:00

Give Up?

Enter answer here

/ 8 guessed

The quiz is paused. You have remaining.

Scoring
You scored / = %

    This beats or equals
    % of test takers
    also scored 100%
    
The average score is 

      Your high score is
      
    
Your fastest time is 
more stats >>

Keep scrolling down for answers and more stats ...

Function	Description
AVERAGEIF	Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS	Returns the average (arithmetic mean) of all cells that meet multiple criteria.
COUNTIF	Counts the number of cells within a range that meet the given criteria
COUNTIFS	Counts the number of cells within a range that meet multiple criteria
IF	Specifies a logical test to perform
IFERROR	Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
SUMIF	Adds the cells specified by a given criteria
SUMIFS	Adds the cells in a range that meet multiple criteria