Excel Functions and Formulas Introduction

Create a formula | Edit a formula | Copy a formula | Insert a function

This post will guide you how to create new function or formulas in excel. How to edit a formula in excel? How to copy or paste a formula in excel 2013?

What is Excel Formulas?

A formula always starts with an equal sign (=), which can be followed by numbers, math operators (like a + or – sign for addition or subtraction), and built-in Excel functions, which can really expand the power of a formula.

In short, excel formulas is an expression consist of the following elements:  Math operators (+,-,*,/)Cell references (row or column name or range: A2:A5), worksheet functions(such as: date, time, count).

Excel formulas example:

=B1+B2

The above formulas example will add the value of cell B1 to the value of cell B2.

Create a Formula

If you want to create a formula, you just need to type it in formula bar under excel ribbon.

For example, enter values in A2 and A3 cells, while you clicking A4 cell, you will noticed that the excel formula bar is blank… now enter one formula for the current cell A4, like as: =A2+A3, then the calculated result will be shown in the Cell A4.

1# Input values in A2 and A3 cells

input values in A2 and A3

2# clicking A4 cell, checking the excel formula bar

3# enter one formula in the formula bar: =A2+A3

enter formula 1

4# let’s see the results in the cell A4, it will add the summing value A2 and A3 to A4 cell.

enter formula result

Edit a Formula

If you want to modify excel formula for a special excel cell, you just need to click that cell , then edit its formula in the formula bar. Let’s see the below steps:

1#  click one cell that you want to edit its formula

2# modify the formula as: =A2*A3

edit a formula1

3# then press “enter” , let’s see the current result.

edit a formula result

Copy a Formula

If you want to copy one cell formula(A4) to another cell(B4), just following the below steps:

1# clicking the cell A4, right click it and then click “copy” or just press key “CTRL” + “C”

copy a formula 1

2# clicking the cell B4, then right click it , click “Paste Formula” under “Paste Options:

copy a formula 1

3# Let’s see the result:

copy a formula 1

Insert a Function/using Excel built-in function

If you want to insert a function in excel formula bar for one cell, you can just type “=” sign, and then type any alphabet you will see that the searched functions. Or just click “Insert Function” button next to formula bar. Let’s see the below steps:

1# select one cell, such as: C4

2# type “=” sign, then input “S” character, you will see that all functions starting with “S” will show.

excel insert function

Or you can just only click “Insert Function” button to select functions.

excel insert function

excel insert function

Let’s see the results:

excel insert function

 

 

Leave a Reply