Microsoft Excel Functions: Excel Error Values and Formula Reference (Part 5)
Explore “Excel Error Values and Formula Reference” in this Microsoft Excel Functions lesson. Part 5 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Excel Error Values
Contents
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 01: original teaching slides for this study series.
Excel Error Values
Excel Error Values Error Value | Description/Explanation #DIV/0! | The formula is trying to divide by zero. This also occurs when the formula attempts to divide by what’s in a cell that is empty (that is, by nothing). #NAME? | The formula uses a name that Excel doesn’t recognize. This can happen if you delete a name that’s used in the formula or if you have unmatched quotes when using text.
#N/A | The formula is referring (directly or indirectly) to a cell that uses the NA function to signal that data is not available. Some functions (for example, VLOOKUP) can also return #N/A. #NULL! | The formula uses an intersection of two ranges that don’t intersect. #NUM! | A problem with a value exists; for example, you specified a negative number where a positive number is expected.
#REF! | The formula refers to a cell that isn’t valid. This can happen if the cell has been deleted from the worksheet. #VALUE! | The formula includes an argument or operand of the wrong type. An operand is a value or cell reference that a formula uses to calculate a result.
Function | Formulas
Function | Formulas Count | Count Numbers =COUNT(Start_Cell:End_Cell) | Count Alphabet =COUNTA(Start_Cell:End_Cell) | Countif =COUNTIF(Range,Criteria) | Countifs =COUNTIFS(Range1,Criteria,Range2,Criteria,……) Sum | Sum =SUM(Start_Num:End_Num) =SUMIF(Range,Criteria,Sum_Range) =SUMIFS(Sum_Range,Range1,Criteria1,Range2,Criteria2,…….) Average | Average =AVERAGE(Start_Num:End_Num) | Averageif
=AVERAGEIF(Range,Criteria,Average_Range) | Averageifs =AVERAGEIFS(Average_Range,Range1,Ceriteri1,Range2,Criteria2,…..)
Review questions and answers
What are the key points about Excel Error Values?
Excel Error Values Error Value | Description/Explanation #DIV/0! | The formula is trying to divide by zero. This also occurs when the formula attempts to divide by what’s in a cell that is empty (that is, by nothing). #NAME? | The formula uses a name that Excel doesn’t recognize. This can happen if you delete a name that’s used in the formula or if you have…
What are the key points about Function | Formulas?
Function | Formulas Count | Count Numbers =COUNT(Start_Cell:End_Cell) | Count Alphabet =COUNTA(Start_Cell:End_Cell) | Countif =COUNTIF(Range,Criteria) | Countifs =COUNTIFS(Range1,Criteria,Range2,Criteria,……) Sum | Sum =SUM(Start_Num:End_Num) =SUMIF(Range,Criteria,Sum_Range) =SUMIFS(Sum_Range,Range1,Criteria1,Range2,Criteria2,…….) Average | Average…
More lessons from this document
- Microsoft Excel – Presentation 01 — Part 1
- Microsoft Excel – Presentation 01 — Part 2
- Microsoft Excel – Presentation 01 — Part 3
- Microsoft Excel – Presentation 01 — Part 4
- Microsoft Excel – Presentation 01 — Part 5
Conclusion
The important points in Excel Error Values should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.