coba juga =C6*VLookUp(C6,$G$13:$H$15,2,TRUE)
atau =C6*LookUp(C6,$G$13:$H$15) -Miss Jan Raisin- 2013/2/18 M. Ferdiansyah <[email protected]> > ** > > > Dear Mas Re, > > Coba dengan tabel bantu dan kombinasi rumus index match. > > file terlampir > > > > Dear Suhu Excel > > > > mohon untuk bantuannya dalam perhitungan insentif borongan. > > adapaun perhitungannya kami lampirkan datanya. > > > > trims > > > > ____________ _________ _________ _________ _________ _________ _________ > Notice : This e-mail (and any attachment) is strictly confidential and > is intended only for the addressee(s)above. Is strictly prohibited to > forward, print, copy, or otherwise reproduce this message that would > allow it to be viewed by any individual not originally listed as > a recipient(s). If you have received this e-mail in error, please > immediately notify the sender and delete this message. The opinions > expressed in this e-mail (and any attachment) are those of the individual > sender and may not necessarily reflect the views of PT Pusri. > ____________ _________ _________ _________ _________ _________ _________ > > >
