belajar jawab: kalo menggunakan rumus seperti ini gmn:
IF(A9="","Null",IF(B9="",null,A9-B9)) salam 2011/4/11 monas monas <[email protected]> > Mohon pencerahan para master Excel > Saya Punya tabel dg kolom a, b, c > Dimana c=a-b (File terlampir) > Kenapa jika kolom a atau b terdapat Null, dan saya terapkan rumus tsb > (c=a-b), hasilnya adalah NOL bukan NULL > bagaimana cara nya agar Jika kolom a atau b terdapat NULL > maka hasil di kolom c adalah NULL juga Bukan NOL > Mhn penjelasan para pakar > Terima kasih sebelumnya.. > -- Rian Wijaya ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------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: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
