Excel

Telicome Bill sheet
100 call minimum charge,Rs 200
>100 per|call charge Rs 3.25 excess call Telicome tax subtotal's 5%
sn Name Teliphone no previwous month Total Excess call Subtotal Tax Billamount Remarks
1 Dhan b d r Rai 14622883 150 200 100 525 26.25 551.25

stuctures :-Total=Curentmonth-previewousmonth
Excesscall:-=if(totall>=100,totall-100)
Subtotal:-=200+excesscall*3.25
Telicome tax:-=subtotall*5%
Billamount:-=subtotall+tax

2, marksheet
other knowledge:-=today shift()enter. sn english Math Scince Social Population Nepali Education Geography Total Persontage Result Division Remarks
Method lookes today date&time. 32 32 32 32 32 32 32 32 256 32 pass 2nd
stuctures:- Total=sum(select all subjects)enter
Persontage:-=total/all subjects)enter
Result:-=if(and(english>=32,math>=32,scince>=32,population>=32,nepali>=32,education>=32,geography>=32),"pass","fail")enter
Division:-=if(persontage>=60,"1st",if(and(persontage60,persontage<45,persontage),"2nd",if(and(persontage<45,persontage>=32),"3rd",no division")))enter
Remarks:-=if(division="1st","excelence",if(division="2nd","well",if(division="3rd","good","tryagain")))enter

3,Eletronic Bills
Pradhikaran facilities:- 20Unit minimum charge Rs 80
21-250 per|unit Rs 7.25>250 per|unit Rs 9.90
sn Name Cutommer no Previousmonth Curentmonth Total unit Bill amount
1 Ghanashyam 1254 150 300 150 1022.5

stuctures:-Total:-=Curentmonth-previeousmonth
Billamount:-=if(Total<20,80,if(total<=250,(Total-20)*7.25+80,if(total>250,(total-250)*9.90+(250-20)*7.25+80)))enter

4, General Bills Office facilities:- 2% Discount
sn Particulars Queentity Rate Amount Discount BillAmount
1 Pattato 5 5 25 0.5 24.5
2 Apple 10 70 700 14 686
3 Rice 25 50 1250 25 1225
4 Biscut 5 80 400 8 392
5 Jeera 4 90 360 7.2 352.8
6 Sugar 25 36 900 18 882
Stucture:-Amount=Queetity*Rate
Discount:-=Total*Discount
BillAmount:-=Amount-Discount