Msaada kwenye excel!

[Elai]

wataalamu wa excel msaada. Mimi ni mwalimu. Nina orodha ya wanafunzi wangu na alama walizopata katika mtihani. Lengo ni kubadilisha alama katika asilimia kwenda kwenye mfumo wa daraja A, B, C , D OR F kwa kila somo. Changamoto inakuja pale ninapo kopi formula ya nested if function. Kwenye masomo ya option ninapata error kwa sababu hayana alama (yapo wazi). Nitatatuaje hili? Ahsante.

 

[Ushimen]

Pole sana Mkuu.
Ebu ngoja wakuje nami nijifunze hapa

 

[shadownet]

Search youtube "setting class grades in excel"

 

[tarawe]

Tumia if formula.
Iko pouwa

 

[ofisa]

Tumia if formula.
Iko pouwa

hueleweki

 

[tarawe]

Unaijua if formula?

 

[HACHOKI TALEMWA]

=if(D4="-", " ", if(D4>=81,"A ",..................) jaribu hapo

 

[rechungura1]

na mimi nahitaji kuondoa penalty kwenye template yangu
yaan grade ziwe calculated bila kumpiga mtu penalty but masomo saba ya kwanza ndo yawe calculated first......

 

[HACHOKI TALEMWA]

na mimi nahitaji kuondoa penalty kwenye template yangu
yaan grade ziwe calculated bila kumpiga mtu penalty but masomo saba ya kwanza ndo yawe calculated first......

Grade au division

 

[simplemind]

Google excel conversion of marks to grades.

 

[rechungura1]

Grade au division

division

 

[HACHOKI TALEMWA]

division

Division inabidi uwe na point
I.e =sum(if(LARGE (A1, B1, C1,........{1,2,3,4,5,6,7} ) <=21,5,IF(................))
Utapata point then tumia point kutafuta division kwa kutumia formula kama ya grade

Sent from my TECNO H6 using JamiiForums mobile app

 

[Nyorji]

Kama hujafanikiwa ni inbox

 

[Elai]

Changamoto aliyonayo hata mimi ilinikuta. Tusubiri wajuzi watatusaidia.

 

[Msafiri Kasian]

division

tumia vlookup, hiyo nyingine ni ndefu zaidi na pengine ngumu kuielewa

 

[Msafiri Kasian]

wataalamu wa excel msaada. Mimi ni mwalimu. Nina orodha ya wanafunzi wangu na alama walizopata katika mtihani. Lengo ni kubadilisha alama katika asilimia kwenda kwenye mfumo wa daraja A, B, C , D OR F kwa kila somo. Changamoto inakuja pale ninapo kopi formula ya nested if function. Kwenye masomo ya option ninapata error kwa sababu hayana alama (yapo wazi). Nitatatuaje hili? Ahsante.

Excel kupanga matokeo, divisions na points

 

[Msafiri Kasian]

fuatilia hiyo post hapo juu

 

[Mediocrist]

Vlookup ni rahisi sana tena ni nzuri kwa hiyo kitu yako

 

[Mediocrist]

Nina examples sheet nili design kwa hicho kitu ulichotaka naweza kutumia ili uendelee na mishe yako