IT Help Desk > Use of PC

Microsoft Excel: Learning Tutorial

<< < (10/12) > >>

ashiqbest012:
Functions of Part-19 and part-20

Cell no D9 (Accrued) the function is =3500-C9

N.B. Suppose, I have got in every month about 3500 tk. so, the function start with =3500-c9 . If your get the rent 8000 then type =8000-C9 instead of =3500-c9.

Cellno F9, the function is =3500-E9+D9

Cell no H9 the function is =3500-G9+F9

Cell no J9, the function is =3500-I9+H9

I hope, you understand the consistency of the function.

Cell no C19 (Total) the function is =SUM(C9:C17)
Cell no D20 the function is =SUM(D9:D17)

AE9 no cell the function is =C9+E9+G9+I9+K9+M9+R9+T9+V9+X9+Z9+AB9

AE19 no cell the function is =C19+E19+G19+I19+K19+M19+R19+T19+V19+X19+Z19+AB19

Thank you everybody

ashiqbest012:

ashiqbest012:
Red Color indicates the Collection amount and Green color indicates the uncollected amount.

First of all, cell no B7, no shop monthly pays 1200 tk. So, there is no unpaid amount available in January-May. However, in month of June, I collected 1000 tk. instead of 1200. So, there was remaining 200 tk. Every work is automatically done by Ms.Excel.

ashiqbest012:
Type on the Cell no C7 is =1200-B7

NB. Suppose your rent is 5000 taka. then type on the cell no C7 is =5000-B7

Type on the Cell no C8 is =1200+C7-B8


NB. Suppose your rent is 5000 taka. then type on the cell no C8 is =5000+C7-B8

Accordingly, C9, C10, C11 no cell =1200+C8-B9, =1200+C9-B10, =1200+C10-B11

Let's go for download soft copy

ashiqbest012:

Navigation

[0] Message Index

[#] Next page

[*] Previous page