RUMUS EXCEL ANGGUN SASMITA

RUMUS NAMA BARANG : =IF(LEFT(B8;1)="G";"GULA JAWA";IF(LEFT(B8;1)="A";"AQUA";IF(LEFT(B8;1)="D";"DAGING";IF(LEFT(B8;1)="F";"FROZEN FOOD")

RUMUS HARGA KULAAN : =MID(B8;2;3)

RUMUS HARGA JUAL : =IF(MID(B8;2;3)="123";"5000";IF(MID(B8;2;3)="345";"10000";IF(MID(B8;2;3)="456";"15000";IF(MID(B8;2;3)="678";"20000")

RUMUS KEUNTUNGAN : =E8*10%

RUMUS BONUS : =E8*5%

RUMUS PAJAK : =E8*2%

RUMUS TOTAL : =E8+F8+G8+H8

RUMUS NILAI TERTINGGI : =MAX(I8:I17)

RUMUS NILAI TERENDAH : =MIN(I8:I17)

RUMUS JUMLAH KESELURUHAN : =SUM(I8:I17)

RUMUS RATA - RATA : =AVERAGE(I8:I17)