Page 31 - Trackpad_V1_Book 6_Flipbook
P. 31

COMMON ERRORS IN FUNCTIONS
                 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 divider 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
                  #NAME?
                                         Excel.                                     function  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. Are there any function or formula that can help her to make her
                   task easier? Do you think you should be helping people whenever you see an opportunity?







                        Hashtag

                      #Operator: An operator is a symbol that is used to perform calculation

                      #Function: A predefined formula in Excel







                                                                                 Formulas and Functions in Excel 2010  29
   26   27   28   29   30   31   32   33   34   35   36