Take another quiz >

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:
First submittedMarch 30, 2015
Last updatedMarch 30, 2015
Times taken36
4:00
Enter answer here
0
 / 8 guessed
The quiz is paused. You have remaining.
Scoring
You scored / = %
This beats or equals % of test takers
The average score is
Your high score is
Your best time is remaining
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
No comments yet.