Page 32 - KEC Khaitan C6 Flipbook
P. 32

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 column.
                                          display the number.
                                          Division by zero is an invalid     Change the divisor to a
                    #Div/0!
                                          operation.                         non-zero value.

                                          The formula contains an invalid    Check if the data type is the same in all
                    #VALUE!
                                          operation.                         the referred cells.

                    #N/A                  Data is not available.             Check if the data is entered in the cell.

                                          The function name is not
                    #NAME?                                                   Check and correct the function name.
                                          recognised by Excel.

                    #REF!                 The cell reference is not valid.   Check and correct the cell ranges.


                                          The formula or function contains   Ensure there are no special symbols such
                    #NUM!
                                          invalid numeric values.            as $ or % being used with the number.






                                    Envision your favourite tech personality as a Gizmo Gadget. How would you paint
                                    their portrait in Excel?






                                                                                           21 st   #Initiative
                                                          Self Reflection                Century   #Leadership & Responsibility
                                                                                           Skills
                   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: An operator is a symbol that is used to perform calculation
                      #Function: A predefined formula in Excel







                   30   Premium Edition-VI
   27   28   29   30   31   32   33   34   35   36   37