Dear Mr Roy, bisa dicoba rumus ini : =IF(C4<=29;VLOOKUP(B4;$H$5:$J$10;3;0);IF(C4>=30;VLOOKUP(B4;$H$5:$J$10;2;0)))
semoga sesuai harapan. Salam, DD ________________________________________ From: belajar-excel@yahoogroups.com [belajar-excel@yahoogroups.com] Sent: Monday, March 09, 2015 12:28 PM To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Update Harga [1 Attachment] Dear Para Tetua Excel Mohon bantuannya untuk kasus excel yang membuat saya sakit kepala mencari jalan keluarnya Terima kasih atas bantuannya Regard Roy M. ________________________________ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited. ------------------------------------ ------------------------------------ ============================================================ Pojok Lowongan Kerja yang disediakan milis : http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html *** Posting lowongan kerja : ke link tersebut dan klik New Topic ============================================================ bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscr...@yahoogroups.com posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: belajar-excel-ow...@yahoogroups.com keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscr...@yahoogroups.com --------------------------------------------------------------------- ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: belajar-excel-dig...@yahoogroups.com belajar-excel-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: belajar-excel-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/