Formula writing using Excel Function

Lets understand how to write a complete formula in Excel. Let’s start with one of the basic formula of adding numbers in Excel by using simple Sum function. Formula writing is a simple 3 step process as explained below-

  1. Selecting Cell and function to be used in Formula

As explained above, whenever we type an equal to (=) sign Excel understands this as a formula.

 In picture 1, as one types equal(=) sign in cell F2 and then type name SUM, Excel understands that we want to use SUM function in formula and shows the list of related functions with name “SUM”. By default, function SUM is selected as shown.

Picture 1

  1. Understanding Parameters required

Press tab key in picture 1 to select this function. Once we press tab key, SUM function is selected with opening parentheses(brackets) and showing list of parameters(number 1, number 2…) which have to be added. See picture 2 below.

Picture 2

 3. Selecting Parameters required in formula(See picture 3 below) - 2 Ways to add parameters – One by Arrow keys on keyboard & Two by Click of a Mouse

By Arrow Keys on Keyboard

List of parameters which have to be added can be selected by first highlighting the first cell(B2) in range and then press SHIFT key and by using arrow key select last cell in range(E2) and finally inputing closing parentheses “)”& pressing ENTER key to display formula results in E2.

By Click of a Mouse

Parameter selection can also be done by a mouse click, select first cell in range(B2) and drag the mouse till last cell(E2) in range and finally inputing closing parentheses “)”& pressing ENTER key to display formula results in E2.

Picture 3