giúp mình viết công thức xếp loại học sinh với (1 người xem)

[tien810535]

[TABLE="class: MsoNormalTable, width: 271"]
[TR]
[TD="width: 362"]
Hãy Xếp Loại cho học sinh dựa vào các yêu cầu sau:
- Giỏi : ĐTB >=9 và không có môn nào điểm nhỏ hơn 8
- Khá : ĐTB >=7 và không có môn nào điểm nhỏ hơn 6
- - TB : ĐTB >=5 và không có môn nào điểm nhỏ hơn 4
- - Yếu : Các trường hợp còn lại



[/TD]
[/TR]
[TR]
[TD="width: 362"]

[TD="class: xl39, width: 587, colspan: 10"]KẾT QUẢ HỌC TẬP NĂM 2002[/TD]

[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]

[TD="class: xl41, width: 72"]Tên
Học Sinh[/TD]
[TD="class: xl42, colspan: 3"]Môn Chính[/TD]
[TD="class: xl42, colspan: 3"]Môn Phụ[/TD]
[TD="class: xl43"]ĐTB[/TD]
[TD="class: xl43"]Vị Thứ[/TD]
[TD="class: xl43"]Xếp Loại[/TD]

[TD="class: xl41, width: 52"]Toán[/TD]
[TD="class: xl41, width: 58"]Lý[/TD]
[TD="class: xl41, width: 44"]Hoá[/TD]
[TD="class: xl41, width: 52"]Sinh[/TD]
[TD="class: xl41, width: 40"]Sử[/TD]
[TD="class: xl41, width: 39"]Địa[/TD]

[TD="class: xl44"]Anh[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]7[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]10[/TD]
[TD="class: xl45, align: right"]6.1[/TD]
[TD="class: xl46, align: right"]5[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Nguyệt[/TD]
[TD="class: xl44"]3[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]3[/TD]
[TD="class: xl44"]2[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl45, align: right"]4.2[/TD]
[TD="class: xl46, align: right"]9[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Vũ[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl45, align: right"]5.1[/TD]
[TD="class: xl46, align: right"]8[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Châu[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl45, align: right"]8.4[/TD]
[TD="class: xl46, align: right"]2[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Thành[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl45, align: right"]6.4[/TD]
[TD="class: xl46, align: right"]4[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Vân[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl45, align: right"]7.2[/TD]
[TD="class: xl46, align: right"]3[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Trang[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]7[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl45, align: right"]5.6[/TD]
[TD="class: xl46, align: right"]6[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Vinh[/TD]
[TD="class: xl44"]10[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]10[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl45, align: right"]9.2[/TD]
[TD="class: xl46, align: right"]1[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Hoàng[/TD]
[TD="class: xl44"]7[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]1[/TD]
[TD="class: xl44"]2[/TD]
[TD="class: xl44"]2[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl45, align: right"]3.7[/TD]
[TD="class: xl46, align: right"]10[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Thuỷ[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]2[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl45, align: right"]5.2[/TD]
[TD="class: xl46, align: right"]7[/TD]
[TD="class: xl46"][/TD]

[/TD]
[/TR]
[TR]
[TD="width: 362"]
[/TD]
[/TR]
[TR]
[TD="width: 362"]

[/TD]
[/TR]
[TR]
[TD="width: 362"]
[/TD]
[/TR]
[/TABLE]

 

[nhat chi mai]

[TABLE="class: MsoNormalTable, width: 271"]
[TR]
[TD="width: 362"]
Hãy Xếp Loại cho học sinh dựa vào các yêu cầu sau:
- Giỏi : ĐTB >=9 và không có môn nào điểm nhỏ hơn 8
- Khá : ĐTB >=7 và không có môn nào điểm nhỏ hơn 6
- - TB : ĐTB >=5 và không có môn nào điểm nhỏ hơn 4
- - Yếu : Các trường hợp còn lại



[/TD]
[/TR]
[TR]
[TD="width: 362"]

[TD="class: xl39, width: 587, colspan: 10"]KẾT QUẢ HỌC TẬP NĂM 2002[/TD]

[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]
[TD="class: xl40"][/TD]

[TD="class: xl41, width: 72"]Tên
Học Sinh[/TD]
[TD="class: xl42, colspan: 3"]Môn Chính[/TD]
[TD="class: xl42, colspan: 3"]Môn Phụ[/TD]
[TD="class: xl43"]ĐTB[/TD]
[TD="class: xl43"]Vị Thứ[/TD]
[TD="class: xl43"]Xếp Loại[/TD]

[TD="class: xl41, width: 52"]Toán[/TD]
[TD="class: xl41, width: 58"]Lý[/TD]
[TD="class: xl41, width: 44"]Hoá[/TD]
[TD="class: xl41, width: 52"]Sinh[/TD]
[TD="class: xl41, width: 40"]Sử[/TD]
[TD="class: xl41, width: 39"]Địa[/TD]

[TD="class: xl44"]Anh[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]7[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]10[/TD]
[TD="class: xl45, align: right"]6.1[/TD]
[TD="class: xl46, align: right"]5[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Nguyệt[/TD]
[TD="class: xl44"]3[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]3[/TD]
[TD="class: xl44"]2[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl45, align: right"]4.2[/TD]
[TD="class: xl46, align: right"]9[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Vũ[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl45, align: right"]5.1[/TD]
[TD="class: xl46, align: right"]8[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Châu[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl45, align: right"]8.4[/TD]
[TD="class: xl46, align: right"]2[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Thành[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl45, align: right"]6.4[/TD]
[TD="class: xl46, align: right"]4[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Vân[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl45, align: right"]7.2[/TD]
[TD="class: xl46, align: right"]3[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Trang[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]7[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl45, align: right"]5.6[/TD]
[TD="class: xl46, align: right"]6[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Vinh[/TD]
[TD="class: xl44"]10[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]10[/TD]
[TD="class: xl44"]8[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl45, align: right"]9.2[/TD]
[TD="class: xl46, align: right"]1[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Hoàng[/TD]
[TD="class: xl44"]7[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]1[/TD]
[TD="class: xl44"]2[/TD]
[TD="class: xl44"]2[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl45, align: right"]3.7[/TD]
[TD="class: xl46, align: right"]10[/TD]
[TD="class: xl46"][/TD]

[TD="class: xl44"]Thuỷ[/TD]
[TD="class: xl44"]6[/TD]
[TD="class: xl44"]2[/TD]
[TD="class: xl44"]4[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]9[/TD]
[TD="class: xl44"]5[/TD]
[TD="class: xl45, align: right"]5.2[/TD]
[TD="class: xl46, align: right"]7[/TD]
[TD="class: xl46"][/TD]

[/TD]
[/TR]
[TR]
[TD="width: 362"]
[/TD]
[/TR]
[TR]
[TD="width: 362"]

[/TD]
[/TR]
[TR]
[TD="width: 362"]
[/TD]
[/TR]
[/TABLE]

Bạn ơi??? bạn đổi sang khung lớn rồi gửi file đính kèm, nhìn thấy cái đề di chuột cũng nản quá... với cái đề.hhuuu

 

[hanhpptc]

Theo đề bài thì:
=IF(AND(dtb>=9,Min(DMon)>=8),"Giỏi",IF(AND(dtb>=7,Min(DMon)>=6),"Khá",IF(AND(dtb>=5,Min(DMon)>=4),"TBình","Yếu")))

 

[luongtranap82]

Nhìn mà thấy nản quá...Xếp loại thì dùng IF(IF(...)) như hanhpptc là được rùi