Q:

What is the difference between a formula and a function?

A:

Quick Answer

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.

Continue Reading

Full Answer

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.

Learn more about Algebra

Related Questions

  • Q:

    What is a formula equation?

    A:

    A formula equation is a visual representation of a reaction using chemical formulas. A chemical formula is an expression that states the number and types of atoms that make up any given molecule using the symbols for the elements and sub-scripted numbers.

    Full Answer >
    Filed Under:
  • Q:

    How do you use an algebra formula sheet to help with math problems?

    A:

    An algebra formula sheet is used to remind you of common algebraic formulas, such as the point-slope form of a line, while you are working through math problems. The best way to use a formula sheet is to write as clearly and concisely as possible and to only include the bare minimum of information necessary to remind you of the formulas and equations that are important for your upcoming exam or assignment.

    Full Answer >
    Filed Under:
  • Q:

    Where can you find a list of all Excel formulas?

    A:

    Find a list of all the formulas and functions for the spreadsheet program Microsoft Excel on sites such as TechOnTheNet.com, PCWorld.com, Office.com and Dummies.com, as of 2015. Each site includes the exact command to execute the function in the program and a description of its purpose.

    Full Answer >
    Filed Under:
  • Q:

    How does "X" vary from "Y"?

    A:

    In functions, "Y" is generally used in place of f(X) to represent the output of the function. This output is dependent on the value of the input, which is represented by "X." In graphs, "Y" represents the vertical axis and "X" represents the horizontal axis.

    Full Answer >
    Filed Under:

Explore