Excel Formulas for Addition

All calculations in Excel are made through formulas which are written in cells where result is required.

Let us do addition of two numbers 5 and 10.

We wish to calculate the addition of two numbers 10 and 5. Let us see how we can add these two numbers in Excel.

1.         Open a blank worksheet.

2.         Click on a cell where you would like to enter the number 10. Say cell A15.

3.         Enter 10 in cell A15.

4.         Click cell where you would like to enter the number 5. Say cell B15.

5.         Click cell where you would like to get the sum of 10 and 5. Say cell C15.

6.         Start the formula. Write equal sign = in cell C15.

7.         After =, write “(“ (left bracket) in cell  C15.

8.         Move mouse and left click on value 10 which is in cell A15. In cell C15, the cell reference A15 is written.

 9.        Write “+” after “A15” in cell C15.

10.        Move mouse and left click on value 5 which is in cell B15. In cell C15, the cell reference B15 is written.

11.        Write “) “ (right bracket) in cell  C15.

12.        Press Enter key

The answer 15 is shown in cell C15.

If you click on cell C15, the formula “=A15+B15” is displayed the formula bar to the right of fx in the Toolbar.

The main steps along with the entries are shown in the slide below. The worksheet MTH302-lec-02 contains the actual entries.

Previous

TOC

Next