Contoh Tabel
Rumus atau Formula
No.
|
NAMA RUMUS
|
RUMUS
|
1.
|
JENIS
|
=VLOOKUP(C5,$F$12:$I$15,3)
|
2.
|
NAMA
|
=VLOOKUP(C5,F12:$I$15,2)
|
3.
|
HARGA
|
=VLOOKUP(C5,$F$12:$I$15,4)
|
4.
|
BONUS
|
=IF(D5="majalah",10%*F5,5%*F5)
|
5.
|
SETORAN
|
=(F5-H5)*G5
|
6.
|
TOTAL SETORAN
|
=SUM(I5:I10)
|
7.
|
TOTAL SETORAN DARIKORAN
|
=SUMIF(D5:D10,"koran",I5:I10)
|
8.
|
RATA-RATA EKSEMPLAR
|
=AVERAGE(G5:G10)
|
9.
|
JUMLAH PENGECER
|
=COUNTA(B5:B10)
|
No comments:
Post a Comment