Hai Algoritma;

coba begini:
=VLOOKUP(E2,'tbl discount'!$B$4:$F$50,MATCH(D2,'tbl discount'!$B$3:$F$3,0),1)
Copas kebawah


Wassalam

~ Bagus ~



  ----- Original Message -----
  From: ahmad algoritma
  To: [email protected]
  Sent: Sunday, March 30, 2014 9:56 AM
  Subject: ]] XL-mania [[ Discount banyak kreteria [1 Attachment]




  Hallo para Xl-mania
  salam kenal, lansung aza nih saya minta pencerahan gimana bikin rumus 
discount dengan banyak kreteria. lebih lengkapnya terlampir.

  salam ahmad

  

Kirim email ke