Takde keje?

Sape kate aku takde keje... Ni keje yg aku wat dari pagi tadi... Mencarik formula utk projek yg kene wat nih. Sorry la tak dpt taip pepanjang. Hmm... Ni nak kene carik formula baru lak lepas nih... tolon tolon...

Err sesaper tahu pasal Excel, please ajarkan aku. Saya ni budak baru belajar... Kalau salah tolong jolokkan...

Sebahagian keje aku. Tolong analisis dan bagi aku cara senangnye kalau paham... Aku banje teh tarik 1.
=VLOOKUP($B3,data,10,FALSE)
=VLOOKUP(C3,pr,21,FALSE)
=IF(R3="ST",5,IF(R3="ET",4,IF(R3="OT",3,IF(R3="TH",2,IF(R3="BTH",1,"")))))
=(T3+U3)/2
=IF(G10="Band G","Not",IF(G10="BG52","Not",IF(AND(V10>=3.5,P10>=3),"Eligible","Not")))
=IF(W10="Eligible","",IF(AND(V10>=3,P10>=5),"Eligible","Not"))
=IF(G9="Band G",IF(AND(V9>=3.5,P9>=2),"Eligible","Not"),IF(G9="BG 52",IF(AND(V9>=3.5,P9>=2),"Eligible","Not")))
=IF(W9="Eligible","Eligible",IF(X9="Eligible","Eligible",IF(Y9="Eligible","Eligible","Not Eligible")))