Excel formula
၁=က်႐ွံုးဘာသာမ်ား
=IF(E2<40,"ျမန္မာ/","")&
IF(G2<40,"အဂၤလိပ္/","")စသည္ျဖင္
၂=က်႐ွံုးအေရအတြက္
=IF(AND(E2>39,G2>39,I2>39,
K2>39),"ေအာင္","႐ွံုး")
၃=အဆင့္ ABCD တြက္နည္း
=IF((E2:E14<40),"D",IF((E2:E14<60),
"C",IF((E2:E14<80),"B",
IF(E2:E14>79),"A"))))
၄=က်႐ုူွံုးဘာသာအေရတြက္
=COUNTIF(D3:N3,"<40")
၅=ျမန္မာစာက်႐ွံုးဦးေရ
=COUNTIF(E2:E68,"<40")
၆=1F ဦးေရတြက္နည္း
COUNTIF(P2:P68,"1")
2F ဆိုရင္ "2" လိုက္ရံုပ
၇=ေအာင္ျမင္ဦးေရ
COUNTIF(R2:R68,"ေအာင္")
၈=ေပါင္းရန္
=SUM(P70:P74)
၉=က်ားမခြဲနည္း
=IF(OR(LEFT(D2)="မ",LEFT(D2)="န"),"မ","က်ား")
၁၀=အသက္တြက္နည္း
=DATEDIF(B4:C4,"y")&"years",&DATEDIF(B4:C4,"ym")&"months",
&DATEIF(B4:C4,"md")&"days"
Kyaw Min Oo at 11:34 AM
Share
