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
   26   27   28   29   30   31   32   33   34   35   36