Using formulas in excel

Individuals and businesses use excel to calculate either their project business plans, profit margings or calculate home expenses or monthly salary books clearing. But apart from all the complicated usage of this program, if you are the person to use excel for normal purposes and wondering how you should be using formulas in excel?

Though excel is very powerful in terms of functions and formulas and it can work out some of the most complicated mathematical operations but here you will know at initial stage how you could perform basic operations using formulas in excel. So let’s start.

Formula to calculate addition

1. This example shows sales done in last month and this month and now it is required to find gross sales. This can be performed via addition function.

2. Click in the cell H8 to perform addition between last and this month’s sales for shoes and find the gross sales.

3. Now press “equals” sign and click cell F8 to select last month sales of shoes.

4. Now type “+” sign to perform addition.

5. Click cell G8 for this month sales of shoes.

6. Finally, press Enter key. You got your total sales for shoes for current and previous month.

7. Now click cell, bring your cursor to bottom-right, notice the cursor changes to + sign.

8. Now press/hold left mouse button, drag as below.The total sales of all items are calculated.

Formula to calculate subtraction

1. In this example, the total and last month’s sales are known and it is required to find this month sales. This is where subtraction is required. Here is how to do it using excel.

2. Click cell H8.

3. Press “=” sign and the click cell F8.

4. Now type “-” sign to perform subtraction.

5. Click cell G8 for last month sales of laptops.

6. Finally, press Enter key. You got this month’s sales.

7. Again hover your cursor to the the location mention as below and notice cursor turns to + sign.

8. Now press and hold left mouse button and drag, current month sales are hence calculated.

Formula to calculate multiplication

1. In this example, the Items in one shop are given and the total number of shops are given where the specific item is placed. If you want to calculate total qty of each item in total shops, you need to calculate it using multiplication.

2. Click cell H8

3. Now press “equals” sign and click cell F8.

4. Now type “ * ” sign.

5. Click cell G8.

6. Now, press Enter key. The multiplication is done.

7. Again bring your cursor to the bottom right to change it to + sign.

8. Now press and hold left mouse button and drag, the total qty of all items are calculated.

Formula to calculate division

1. This example tells total qty of each item and number of shops in which the total items are place. Now if we need to calculate qty of items in one shop, it can be done using division.

2. Click in the cell H8.

3. Now press “equals” sign and click cell F8.

4. Now type “ / ” sign to perform division.

5. Click cell G8 for number of shops.

6. Finally, press Enter key. Here is the answer to how many laptops are there in one shop.

7. Now click the cell and bring your cursor to the bottom right of the handle, notice the cursor changes to plus sign.

8. Now press and hold left mouse button and drag, the total qty of all items in one shop are calculated.

So this is how you or anyone should be using formulas in excel. Need to edit Word/Excel/PPT file free of charge? Download WPS Office edit files like without any cost. Download now! to get enjoyable working experience.