Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 41 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 41

    Tech Funda

                           To open Insert Function Wizard dialog box: Ctrl +F2

                     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

                      #Div/0!       Division by zero is an invalid operation. Ensure the divisor is not zero

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

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

                      #Name?        The function name is not recognised       Check and correct the function name.
                                    by Calc.

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

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

                            Restart

                           LibreOffice Calc allows users to create custom formulas to perform calculations on their
                          data.
                          Formulas in LibreOffice Calc begin with an equal sign.

                          When performing calculations using a formula, Calc follows certain rules of precedence.
                           Calc also contains built-in formulas called functions that make it easy to perform common
                          calculations on data.

                                                                                     Formulas and Functions in Calc      39

| 36 37 38 39 40 41 42 43 44 45 46 |