Q:

What is the difference between a formula and a function?

A:

Formulas and functions are both important tools when creating an Excel spreadsheet; while users type formulas right into the bar at the top of the spreadsheet, formulas come built within the application itself, so it actually comprises a special sort of formula. While it is not possible to nest a formula in Excel, it is possible to do so with functions.

In Excel, formulas allow the user to carry out mathematical calculations ranging from simple addition or subtraction and ranging to far more complex operations. Entering a formula always begins with clicking on the cell where the result of the formula is to appear and then entering the equal sign (=) to indicate to the program that a formula is about to appear.

It is possible to enter numbers directly into the formula, but it is better to enter cell locations, so that if changes are necessary to those values, the formula still works. Using constant numbers means that it is necessary to revise the formula with each change.

Functions add flexibility to spreadsheets by bringing decision-making and other elements into the process. Functions test certain conditions within the spreadsheet to see if they are true. Depending on the answer, other calculations take place. For example, a function could test sales price levels for certain merchandise items. If shipping is based on the price of items, the subsequent calculation could apply shipping fees to a bill after the customer has placed the order.


Is this answer helpful?

Similar Questions

  • Q:

    What is a formula bar?

    A:

    The formula bar is a feature in Microsoft Excel; this part of the software appears at the top of the Excel window and allows users to edit or enter information in the spreadsheet's cells. This information that can be entered or edited through the formula bar includes formulas, which are combinations of letters, numbers and symbols that can help users perform calculations, such as tabulating the values of an entire column.

    Full Answer >
    Filed Under:
  • Q:

    What are all math formulas used for?

    A:

    Math formulas are used to define relationships between a number of variables. Although math formulas can be expressed in the form of equations, not all equations are math formulas. The variables in an equation are denoted by symbols such as "X" or "Y", which represent values not already known. For example, the math formula for working out the volume of a cube, or box, is given by V= lwh.

    Full Answer >
    Filed Under:
  • Q:

    How do you insert a check box in an Excel spreadsheet?

    A:

    To insert a check box in an Excel spreadsheet, enable the Developer tab from Settings. Once the tab is visible, use it to drag and drop a check box.

    Full Answer >
    Filed Under:
  • Q:

    What is a diagonal matrix?

    A:

    A diagonal matrix is a square matrix that has non-zero elements only in the diagonal that runs from the top left to the bottom right. A diagonal matrix is also a symmetrical matrix.

    Full Answer >
    Filed Under:

Explore