Page 31 - Chinmaya_C6_flipbook
P. 31
We may get an error while performing calculations using functions. Some common errors are:
Error Meaning Troubleshooting Tip
The column is not wide enough to Increase the width of the
####
display the number. column.
Change the divisor to a
#Div/0! Division by zero is an invalid operation.
non-zero value.
The formula contains an invalid Check if the data type is the
#VALUE!
operation. same in all the referred cells.
Check if the data is entered in
#N/A Data is not available.
the cell.
The function name is not recognised by Check and correct the function
#NAME?
Excel. name.
Check and correct the cell
#REF! The cell reference is not valid.
ranges.
Ensure there are no special
The formula or function contains invalid
#NUM! symbols such as $ or % being
numeric values.
used with the number.
Life Skills & Values
Self Reflection
Your mother has been preparing a list of grocery items with their price. She has been manually
Self Reflection
calculating the total amount. Is there any function or formula that can help her make her task
easier? Do you think you should be helping people whenever you see an opportunity?
Hashtag
#Operator: A symbol that is used to perform calculation
#Function: A predefined formula in Excel
Formulas and Functions in Excel 2016 29

