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

 

 

Related Posts

Converting Week Number to Date
convert week to date4

This post will guide you how to convert a week number to a date with a formula in Excel. How do I calculate a date from a week number and a year with formula in Excel. Or how to get ...

Excel Vlookup From Another Workbook
vlookup from another worksheet

This post will guide you how to lookup value from another workbook in Excel. How do I use VLOOKUP function across multiple workbooks in Excel. How to vlookup a value from another workbook with a formula in Excel. Excel Vlookup ...

Excel DVARP Function
excel dvarp examples1

This post will guide you how to use Excel DVARP function with syntax and examples in Microsoft excel. Description The Excel DVARP Function will get the variance of a population based on the entire population of numbers in a column ...

Excel DVAR Function
excel dvar examples1

This post will guide you how to use Excel DVAR function with syntax and examples in Microsoft excel. Description The Excel DVAR Function will get the variance of a population based on a sample of numbers in a column in ...

Excel DSUM Function
excel dsum examples1

This post will guide you how to use Excel DSUM function with syntax and examples in Microsoft excel. Description The Excel DSUM Function will add the numbers in a column or database that meets a given criteria. And so you ...

Excel DSTDEVP Function
excel dstdevp examples1

This post will guide you how to use Excel DSTDEVP function with syntax and examples in Microsoft excel. Description The Excel DSTDEVP returns the standard deviation of a population based on the entire population of numbers in a column or ...

Excel DSTDEV Function
excel dstdev examples1

This post will guide you how to use Excel DSTDEV function with syntax and examples in Microsoft excel. Description The Excel DSTDEV returns the standard deviation of a population based on a sample of numbers in a column or database ...

Excel DMIN Function
excel dmin function example1

This post will guide you how to use Excel DMIN function with syntax and examples in Microsoft excel. Description The Excel DMIN returns the minimum value from a database or a column of a list that matches the specified conditions. ...

Excel DPRODUCT Function
excel dproduct examples1

This post will guide you how to use Excel DPRODUCT function with syntax and examples in Microsoft excel. Description The Excel DPRODUCT returns the product of values from a set of records that match criteria that you specify. The DPRODUCT ...

Excel XIRR Function
excel xirr examples1

This post will guide you how to use Excel XIRR function with syntax and examples in Microsoft excel. Description The Excel XIRR function returns the internal rate of return for a series of cash flows that is not necessarily periodic. ...

Sidebar