Msaada kwenye excel!

E

Elai

Senior Member

May 26, 2011

156

11

• Jun 21, 2017

• #1

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

Platinum Member

Oct 24, 2012

43,995

110,390

• Jun 21, 2017

• #2

Pole sana Mkuu.
Ebu ngoja wakuje nami nijifunze hapa

 

shadownet

Senior Member

Aug 4, 2015

133

678

• Jun 21, 2017

• #3

Search youtube "setting class grades in excel"

 

T

tarawe

Member

Jan 28, 2017

37

19

• Jun 21, 2017

• #4

Tumia if formula.
Iko pouwa

 

ofisa

JF-Expert Member

May 15, 2011

4,362

4,105

• Jun 21, 2017

• #5

tarawe said:

Tumia if formula.
Iko pouwa

Click to expand...

hueleweki

 

T

tarawe

Member

Jan 28, 2017

37

19

• Jun 21, 2017

• #6

Unaijua if formula?

 

H

HACHOKI TALEMWA

Member

Mar 4, 2013

93

9

• Jun 23, 2017

• #7

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

 

R

rechungura1

JF-Expert Member

Jan 19, 2015

387

130

• Jun 23, 2017

• #8

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......

 

H

HACHOKI TALEMWA

Member

Mar 4, 2013

93

9

• Jun 23, 2017

• #9

rechungura1 said:

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......

Click to expand...

Grade au division

 

simplemind

JF-Expert Member

Apr 10, 2009

16,755

9,654

• Jun 23, 2017

• #10

Google excel conversion of marks to grades.

 

R

rechungura1

JF-Expert Member

Jan 19, 2015

387

130

• Jun 24, 2017

• #11

HACHOKI TALEMWA said:

Grade au division

Click to expand...

division

 

H

HACHOKI TALEMWA

Member

Mar 4, 2013

93

9

• Jun 24, 2017

• #12

rechungura1 said:

division

Click to expand...

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

JF-Expert Member

Dec 20, 2012

238

98

• Feb 25, 2018

• #13

Kama hujafanikiwa ni inbox

 

E

Elai

Senior Member

May 26, 2011

156

11

• Feb 25, 2018

• Thread starter
• #14

Changamoto aliyonayo hata mimi ilinikuta. Tusubiri wajuzi watatusaidia.

 

M

Msafiri Kasian

JF-Expert Member

Sep 9, 2011

2,134

664

• Feb 25, 2018

• #15

rechungura1 said:

division

Click to expand...

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

 

M

Msafiri Kasian

JF-Expert Member

Sep 9, 2011

2,134

664

• Feb 25, 2018

• #16

Elai said:

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.

Click to expand...

Excel kupanga matokeo, divisions na points

 

M

Msafiri Kasian

JF-Expert Member

Sep 9, 2011

2,134

664

• Feb 25, 2018

• #17

fuatilia hiyo post hapo juu

 

Mediocrist

JF-Expert Member

Jan 27, 2015

1,709

994

• Feb 25, 2018

• #18

Vlookup ni rahisi sana tena ni nzuri kwa hiyo kitu yako

 

Mediocrist

JF-Expert Member

Jan 27, 2015

1,709

994

• Feb 25, 2018

• #19

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