OK tuir mai ita kontinua deit ho formula excel.
1. Ita hahu ho formula : TOTAL, RATA RATA, MAXIMAL NO MINIMAL
exmplu hanesan imagen iha karaik ho nia exempu:
| Nee ita usa formula sum,average,max,min |
= SUM ( blok husi C2 ba to C7 )
=AVERAGE (SUM ( blok husi C2 ba to C7 )
=MAX (SUM ( blok husi C2 ba to C7 )
= MIN SUM ( blok husi C2 ba to C7 )
2. Formula IF
Exemplu
=COUNTIF(C44:C49,"F") konta total F
=COUNTIF(C44:C49,"F") konta total M
No
|
Nama Siswa
|
Jenis kelamin
|
1
|
Filomenu M.Soares
|
M
|
2
|
Lilita Dos Santos
|
F
|
3
|
Lucas de Jesus
|
M
|
4
|
Letino R.B Lopes
|
M
|
5
|
Mariano Pacheco da
Costa
|
M
|
6
|
Paulina dos Santos
|
F
|
TOTAL F
|
2
|
|
TOTAL M
|
4
|
|
4. Formula : LEFT, MID, RIGHT, LOWER, UPPER, LEN
Tidak ada komentar:
Posting Komentar