Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 18 - 2612 Digimind C6
P. 18

    For example, TODAY() function:

                                                                            Subject: Use of AutoSum Command

                                                                            To use the common functions like SUM, AVERAGE,
                                                                            MAX and MIN,  click on the down-arrow  under
                                                                            Formula tab of the AutoSum command.

                                      Type =TODAY()
                                      in the cell.

                      Press Enter key, the current date appears in the cell.

                      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?

                       16   Premium Edition-VI

| 13 14 15 16 17 18 19 20 21 22 23 |