Microsoft Excel – Function Or Formula

Course - Fun With Excel

Function or Formula –

Sometimes, or in someplace it’s good to used function instead of formula. Function are already predefined for us and also makes your task easy.
Read this given situation –

Let’s assume you need to calculate a total sum, from cell A1 to cell A15. You will create formula for it

= A1 + A2 + A3 + A4 + ………. + A14 + A15 , so it is a time taken and long process, on other hand you can complete this task with the help of function.

Let see how –
= SUM(A1:A15)

Look, function will makes our work easy and also it is a short method. Well here we are considering only 15 cells, think about adding more than 100 cells, so it is good to uses function instead of formula, in order to save time and work more efficiently and smartly.

What is Cell Reference?

As you know, each cell in worksheet have a unique cell address, which is a combination of name of column and row which create that cell by intersecting.
This cell address or cell reference is used to create a formula. Benefits of using cell reference in a formula is that on manipulating a data in a referenced cell the result is update itself, you don’t need to write a formula again and again.

Types of Cell Reference –

Let’s discuss about the types of cell reference. There are three types of cell reference named as –

• Relative cell reference –
• Absolute cell reference –
• Mixed cell reference –