anya'z blog

kolomD4
=rincian!F4

kolomA36
=PROPER("total keseluruhan pemasukan sebelum diskon")
kolomD36
=rincian!F36



Formula Untuk Sheet Rincian
kolomA4
=total!A4



kolomB4
=total!B4



kolomC4
=total!C4



kolomE4
=VLOOKUP(C4,ketentuan!$A$5:$B$12,2)
kolomF4
=D4*E4



kolomA36
=total!A36


kolomF36
=SUM(F4:F35)



Formula Untuk Sheet Diskon
kolomA4
=total!A4







kolomB4
=total!B4







kolomC4
=total!C4







kolomE4
=rincian!E4






kolomF4
=IF(AND(D4>=10,D4<25),"5%",IF(AND(D4>=25,D4<50),"10%",IF(D4>=50,"25%","0")))
kolomG5
=total!D4-(total!D4*diskon!F4)




kolomA36
=PROPER("total pemasukan setelah diskon")



kolomG36
=SUM(G4:G35)







Formula Untuk Sheet Top Five
kolomA4
=total!A4


kolomB4
=total!B4


kolomC4
=total!C4


kolomD4
=total!D4


kolomE4
=D4>=LARGE($D$4:$D$35,5)
kolomD36
=rincian!F36


Formula Untuk Sheet Gudang
kolomC4
=COUNTIF('Top Five'!B4:B35,"Anugrah")


kolomC5
=COUNTIF('Top Five'!B4:B35,"Elite")


kolomC6
=COUNTIF('Top Five'!B4:B35,"Joy Stationery")

kolomC7
=COUNTIF('Top Five'!B4:B35,"Peony")


kolomC8
=COUNTIF('Top Five'!B4:B35,"Pink - Ponk")

kolomC9
=SUM(C4:C8)




kolomC15
=SUMIF(rincian!C4:C35,"Binder",rincian!D4:D35)

kolomC16
=SUMIF(rincian!C4:C35,"Bolpoint",rincian!D4:D35)

kolomC17
=SUMIF(rincian!C4:C35,"Bolpoint",rincian!D4:D35)

kolomC18
=SUMIF(rincian!C4:C35,"Eraser",rincian!D4:D35)

kolomC19
=SUMIF(rincian!C4:C35,"Pen set",rincian!D4:D35)

kolomC20
=SUMIF(rincian!C4:C35,"Pencil",rincian!D4:D35)

kolomC21
=SUMIF(rincian!C4:C35,"Ruler",rincian!D4:D35)

kolomC22
=SUMIF(rincian!C4:C35,"Write book",rincian!D4:D35)
kolomC23
=SUM(C15:C22)