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)