Chapter 44

using formula in a table

To use formula in a table follow these instructions :

First create the following table.

1 / A	B	C	D	E	F
2	Name	Basic	H_Rent	Medical	Total
3	Amena	8500
4	Liton	3550
5	Jamal	4500
6	Priti	5500
7	Rahim	3800
8	Total
9	Average

Now select the cell where you want to sum or average or to use any formula.

Click on FORMULA from TABLE menu.

Or click on the Formula icon at the right of the DATA option from the Layout tab.

Now write the formula or select the formula from the PASTE FUNCTION option.

Click on OK.

Now your table will look like as :

1 / A	B	C	D	E	F
2	Name	Basic	H_Rent	Medical	Total
3	Amena	8500	1700	1700	11900
4	Liton	3550	355	355	4260
5	Jamal	4500	450	450	5400
6	Priti	5500	825	825	7150
7	Rahim	3800	380	380	4560
8	Total	25850	3710	3710	33270
9	Average	5170	742	742	6654

Here the formulas used are :

For H_Rent and Med. in D3 and E3 : =if(c3>6000,c3*20%,if(c3>5000,c3*15%,c3*10%))
For Total in F3 : =SUM(c3:e3)
For Total in C8 : =SUM(c3:c7)
For Average in C9 : =AVERAGE(C3:C7)

For more formula see the Microsoft Excel part.

Was this helpful for you?

Post your question:

Enter your email:

Enter your password: