calculations in excel

1st - Salary Statement

exsempol

1. H_ RENT (House Rent)=Basic 40% .

2. M _ ALL (Medical Allowance)= 10% . 

3. T _ ALL (Travel Allowance)= Basic 5%

4.  Fand (Poor Fand) = Basic 3 %

 Make solution

1. House Rent Cells D2=C2*40% Press Enter . 

2. Medical Allowance Cells E2=C2*10% Press Enter. 

3. Travel Allowance Cells F2=C2*5% Press Enter. 

4. Poor Fand Cells G2=C2*3% Press Enter 

5. Total Cells H2=Sum(C2+D2+E2+F2)-G2 Press Enter .

2nd- Income Tax

exsempol

(1) Basic 10,000 -Income Tax 2%
(1) Basic 15,000 - Income Tax 3%
(2) Basic 20,000- Income Tax 5%
(3) Basic 20,000- UP Income Tax 8%

 Make solution
    Income Tax =If(B2=10,000,B2*2%,If(B2<=15,000,B2*3%,If(B2<=20,000,B2*5 %,If(B2>20,000,B2*8%)))) Press Enter
http://www.thewebsitesforsale.com/ 

3rd- To Calculate Commission and Salary

exsempol
1. Daily sele 10,000 comition 5%
2. Daily sele 15,000 comition 8%
3. Daily sele 50,000 comition 10%
4. Daily sele 10,000 comition 15% 

Commission    

=If(C2=10,000,C2*5%,If(C2<=15,000,C2*8%,If(C2<=50,000,C2*10 %,If(C2>50,000,C2*15%)))) Press Enter 

Total Salary-

         B2+D2 Press Enter 
 4th- To Calculate a electricity bill

  1. electricity use 1-200 unit.= unit 1.75 taka
  2. electricity use 201-400 unit.= unit 2.50 taka
  3. electricity use 401-500 unit.= unit 3.75 taka   
  4. electricity use 500--up unit.= unit 4.50 taka

Interest=If(and(C2>=0,C2<=200),C2*1.75,If(and(C2>=201,C2<=400),C2*2.50,If(and(C2>=401,C2<=500),C2*3.75,C2*4.50))) Press Enter 

5th-  To Calculate Interest


1. interest 100,000 (5%)
2. interest 300,000 (7%)
4. interest 500,000 (9%)
5. interest 10,00,000 (10%) 
5. interest 10,00,000 (15%) 

 Interest If(C2<=100000,C2*5%,If(C2<=300000,C2*7%,If(C2<=500000, C2*9%,If(C2<=1000000,C2*10%,If(C2>1000000,C2*15%))))) Press Enter

6th- To Create tabulation sheet By using logical function ..




GP = D2=If(And(C2>=0,C2<33),0,If(And(C2>=33,C2<40),1,If (And(C2>=40,C2<50),2,If(And(C2>=50,C2<60),3,If(And(C2>=60,C2<70),3.5,If(And(C2>=70,C2<80),4,5)))))) Press Enter
 
F2If(And(E2>=0,E2<33),0,If(And(E2>=33,E2<40),1,If (And(E2>=40,E2<50),2,If(And(E2>=50,E2<60),3,If(And(E2>=60,E2<70),3.5,If(And(E2>=70,E2<80),4,5)))))) Press Enter 

H2 If(And(G2>=0,G2<33),0,If(And(G2>=33,G2<40),1,If (And(G2>=40,G2<50),2,If(And(G2>=50,G2<60),3,If(And(G2>=60,G2<70),3.5,If(And(G2>=70,G2<80),4,5)))))) Press Enter 

J2= If(And(I2>=0,I2<33),0,If(And(I2>=33,I2<40),1,If (And(I2>=40,I2<50),2,If(And(I2>=50,I2<60),3,If(And(I2>=60,I2<70),3.5,If(And(I2>=70,I2<80),4,5)))))) Press Enter 

L2 If(And(K2>=0,K2<33),0,If(And(K2>=33,K2<40),1,If (And(K2>=40,K2<50),2,If(And(K2>=50,K2<60),3,If(And(K2>=60,K2<70),3.5,If(And(K2>=70,K2<80),4,5)))))) Press Enter 

N2If(And(M2>=0,M2<33),0,If(And(M2>=33,M2<40),1,If (And(M2>=40,M2<50),2,If(And(M2>=50,M2<60),3,If(And(M2>=60,M2<70),3.5,If(And(M2>=70,M2<80),4,5)))))) Press Enter 

P2 If(And(O2>=0,O2<33),0,If(And(O2>=33,O2<40),1,If (And(O2>=40,O2<50),2,If(And(O2>=50,O2<60),3,If(And(O2>=60,O2<70),3.5,If(And(O2>=70,O2<80),4,5)))))) Press Enter 

R2 If(And(Q2>=0,Q2<33),0,If(And(Q2>=33,Q2<40),1,If (And(Q2>=40,Q2<50),2,If(And(Q2>=50,Q2<60),3,If(And(Q2>=60,Q2<70),3.5,If(And(Q2>=70,Q2<80),4,5)))))) Press Enter


T2 If(And(S2>=0,S2<33),0,If(And(S2>=33,S2<40),1,If (And(S2>=40,S2<50),2,If(And(S2>=50,S2<60),3,If(And(S2>=60,S2<70),3.5,If(And(S2>=70,S2<80),4,5)))))) Press Enter

V2 If(And(U2>=0,U2<33),0,If(And(U2>=33,U2<40),1,If (And(U2>=40,U2<50),2,If(And(U2>=50,U2<60),3,If(And(U2>=60,U2<70),3.5,If(And(U2>=70,U2<80),4,5)))))) Press Enter 

Total GPA W2=Sum(D2,F2,H2,J2,L2,N2,P2,R2,T2,V2)/10 Grade x2=IF(W2>=5,"A+",IF(W2>=4,"A",IF(W2>=3.5,"A",IF(W2>=3,"B",IF(W2>=2,"C",IF(W2>=1,"D","F")))))) Press Enter