# data[].attributes.body
1.= DATEDIF(C3,D3, "d")
2.=IF(F3="A",50000,if(F3="B",30000,20000))
3.= E3*G3
4.= IF(E3>=30, "H3*90/100", IF(E3>=25, "H3*95/100", "0" ))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=days(D3-C3) 2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=G3*E3 4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.số tiền phải trả: =H3-I3
a=countif(B3:B9,"VN") b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10") d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9) =sumif(F3:F9,"A",H3:H9) =sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"Vn")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:i9)

# data[].attributes.body
câu 1, Số ngày ở là =D3-C3
câu 2, đơn giá =if("A",50000,if("B",30000,20000))
câu 3, thành tiền = E3*G3
câu 4, tiền giảm =if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
câu 5, phải trả = H3-I3
a) =countif(B3:B9,"VN")
b)=coutif(A3:A9,"H*")
c)=coutif(E3:E9,"<=10")
d)=sumif(B3:B9,"VN",E3:E9)
e)=couta(A3:A9)
câu 6, =sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A"I3:I9)

# data[].attributes.body
Câu 1.=D3-C3
Câu 2.=IF(F3="A",50000,IF(F3="B",30000,20000))
Câu 3.=E3*G3
Câu 4.=IF(E3>=30,H3*1/10,IF(E3>=25,H3*1/20,0))
Câu 5.a=COUNTIF(B3:B9,"VN")
b=COUNTIF(A3:A9,"H*")
c=COUNTIF(E3:E9,"<=10")
d=SUMIF(B3:B9,"VN",E3:E9)
e=COUNT(A3:A9)
Câu 6.=SUMIF(F3:F9,"A",E3:E9)
=SUMIF(F3:F9,"A",H3:H9)
=SUMIF(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=IF(F3="A",50000,IF(F3="B",30000,20000))
3.=E3*G3
4.=IF(E3>=30,H3*1/10,IF(E3>=25,H3*1/20,0))
5.số tiền phải trả=H3-I3
a=COUNTIF(B3:B9,"VN")
b=COUNTIF(A3:A9,"H*")
c=COUNTIF(E3:E9,"<=10")
d=SUMIF(B3:B9,"VN",E3:E9)
e=COUNTA(A3:A9)
6.loại phòng A:
=SUMIF(F3:F9,"A",E3:E9)
=SUMIF(F3:F9,"A",H3:H9)
=SUMIF(F3:F9,"A",I3:I9)
loại phòng B:
=SUMIF(F3:F9,"B",E3:E9)
=SUMIF(F3:F9,"B",H3:H9)
=SUMIF(F3:F9,"B",I3:I9)
loại phòng C:
=SUMIF(F3:F9,"C",E3:E9)
=SUMIF(F3:F9,"C",H3:H9)
=SUMIF(F3:F9,"C",I3:I9)
tổng cộng: tổng thành tiền= SUM(H3:H9)
tổng số tiền giảm= SUM(I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5. số tiền phải trả=H3-I3
a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.=H3-I3
a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.số tiền phải trả=H3-I3
a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=counta(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

NGuyễn phạm quốc khiêm

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5. Số tiền phải trả =H3-I3
a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.Số tiền phải trả=H3-I3
a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=count(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)
=sumif(F3:F9,"B",E3:E9)
=sumif(F3:F9,"B",H3:H9)
=sumif(F3:F9,"B",I3:I9)
=sumif(F3:F9,"C",E3:E9)
=sumif(F3:F9,"C",H3:H9)
=sumif(F3:F9,"C",I3:I9)

# data[].attributes.body
1.=D3-C3
2.=if(F3="A",50000,if(F3="B",30000,20000))
3.=E3*G3
4.=if(E3>=30,H3*1/10,if(E3>=25,H3*1/20,0))
5.số tiền phải trả=H3-I3
a=countif(B3:B9,"VN")
b=countif(A3:A9,"H*")
c=countif(E3:E9,"<=10")
d=sumif(B3:B9,"VN",E3:E9)
e=counta(A3:A9)
6.=sumif(F3:F9,"A",E3:E9)
=sumif(F3:F9,"A",H3:H9)
=sumif(F3:F9,"A",I3:I9)

# data[].attributes.body
Group by MaLop;