Enter a Formula | edit a Formula | Operator Precedence | Copy/Paste a Formula | Insert Function

A formula is an expression i beg your pardon calculates the value of a cell. Functions space predefined formulas and are already easily accessible in Excel.

You are watching: What is the difference between a formula and a function

For example, cell A3 below contains a formula which add to the value of cabinet A2 to the worth of cell A1.


For example, cabinet A3 listed below contains the SUM function which calculates the sum of the variety A1:A2.

*

Enter a Formula

To enter a formula, execute the complying with steps.

1. Select a cell.

2. To let Excel recognize that you want to go into a formula, kind an equal sign (=).

3. Because that example, kind the formula A1+A2.

Tip: instead of keying A1 and A2, simply choose cell A1 and cell A2.

4. Readjust the value of cell A1 come 3.

*

Excel automatically recalculates the worth of cabinet A3. This is just one of Excel"s most an effective features!

Edit a Formula

When you select a cell, Excel reflects the value or formula the the cabinet in the formula bar.

*

1. To modify a formula, click in the formula bar and adjust the formula.

*

2. Push Enter.

*

Operator Precedence

Excel uses a default bespeak in i m sorry calculations occur. If a component of the formula is in parentheses, that part will it is in calculated first. It then performs multiplication or division calculations. Once this is complete, Excel will add and subtract the remainder of your formula. See the instance below.

*

First, Excel performs multiplication (A1 * A2). Next, Excel add to the value of cell A3 to this result.

Another example,

*

First, Excel calculates the component in parentheses (A2+A3). Next, the multiplies this result by the value of cabinet A1.


Copy/Paste a Formula

When girlfriend copy a formula, Excel automatically adjusts the cell referrals for each brand-new cell the formula is duplicated to. To recognize this, execute the adhering to steps.

1. Go into the formula shown listed below into cell A4.

*

2a. Select cell A4, best click, and also then click Copy (or push CTRL + c)...

*

...next, select cell B4, appropriate click, and then click dough under "Paste Options:" (or press CTRL + v).

*

2b. Friend can likewise drag the formula to cabinet B4. Select cell A4, click the reduced right corner of cell A4 and drag it throughout to cell B4. This is lot easier and also gives the exact same result!

*

Result. The formula in cell B4 references the worths in shaft B.

*

Insert Function

Every role has the same structure. Because that example, SUM(A1:A4). The name of this function is SUM. The part between the base (arguments) way we offer Excel the selection A1:A4 together input. This role adds the values in cell A1, A2, A3 and also A4. It"s not easy to psychic which function and which debates to usage for every task. Fortunately, the Insert duty feature in Excel helps you with this.

To insert a function, execute the adhering to steps.

1. Select a cell.

2. Click the Insert duty button.

*

The "Insert Function" dialog crate appears.

3. Find for a role or pick a role from a category. For example, pick COUNTIF from the statistics category.

*

4. Click OK.

The "Function Arguments" dialog box appears.

5. Click in the range box and also select the range A1:C2.

6. Click in the Criteria crate and form >5.

7. Click OK.

*

Result. The COUNTIF function counts the variety of cells the are higher than 5.

See more: What Does Running Water While Occurring Infrequently In Deserts,

*

Note: instead of using the Insert function feature, simply form =COUNTIF(A1:C2,">5"). When you come at: =COUNTIF( instead of keying A1:C2, simply pick the variety A1:C2.