Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 44 - CodePilot V5.0 C7
P. 44

    To use the date function in Excel, type =TODAY() into a cell and press
                      the Enter key on your keyboard. This will insert the current date.

                       RAPID RECALL                             Tick ( ) if you know this.

                          1.  Formulas in Excel start with an equal to (=) sign.

                          2.  Cell referencing refers to using the address of a cell in a formula to refer to its value.

                             TYPES OF ERRORS

                      An error occurs when a formula or function in Excel cannot be calculated properly. This may
                      happen  due  to  incorrect  data,  incorrect  formulas  or invalid  references.  Let’s  understand  the
                      types of errors.

                        Error Name                Purpose                   Example                 Description
                       #DIV/0!         Occurs when a number is          =10/0              Division by zero is undefined.
                                       divided by zero.

                       #NAME?          Occurs when a formula name  =SUMM(A1:A5)            “=SUMM” is not a valid
                                       is incorrect or misspelled.      (wrong spelling)   function. “=SUM” is valid.

                       #VALUE!         Occurs when the wrong type  =5 + “Hello”            You cannot add a number
                                       of data is used in a formula.                       and a text string together.
                       #REF!           Occurs when a cell reference  =A1 + B1 (after       Reference to B1 is no longer
                                       is deleted or invalid.           deleting B1)       valid.

                       #N/A            Occurs when a value is not       =VLOOKUP           “Apple” is not found in the
                                       available to a function.         (“Apple”, A1:B5,  range A1:B5.
                                                                        2, FALSE)

                       #NUM!           Occurs when a number is          =SQRT(-1)          You cannot take the square
                                       invalid in a formula.                               root of a negative number.

                       42
                            CodePilot (V5.0)-VII

| 39 40 41 42 43 44 45 46 47 48 49 |