Untuk If lebih dari 7, anda harus pakai Excel 2007. Salam, Hendrik Karnadi
________________________________ From: Belajar Exel <[email protected]> To: [email protected] Sent: Thursday, February 18, 2010 14:17:12 Subject: [belajar-excel] IF lebih banyak Assalamu'alaikum Wr. Wb. Salam kenal to all.... saya punya masalah dalam penggunaan rumus IF nih... ketika kriteria if di bawah 8 (delapan), contoh: [=IF(B8<=1,75;"D";IF( B8<=2;"C-";IF(B8<=2,25;"C";IF( B8<=2,5;"C+";IF( B8<=2,75;"B-";IF( B8<=3;"B";IF(B8<=3,25;"B+";IF( B8<=3,5;"A-";"A" ))))))))] rumus masih bekerja secara normal. Namun ketika kriteria ditambah contoh: [=if(b2<=1,75;"D";if( b2<=2;"C-";if(b2<=2,25;"C";if( b2<=2,50;"C+";if( b2<=2,75;"B-";if( b2<=3;"B";if(b2<=3,25;"B+";if( b2<=3,50;"A-";if( b2<=3,75;"A";"A+ ")))))))) )] ketika dienter selalu muncul konfirmasi "The specified formula canntot be entered because it uses more levels of nesting than are allowed in the current file format." dengan pilihan tombol hanya OK. ketika di OK, kursor langsung ke formula bar dg if yg setelah ke - 8 terblok Get your new Email address! Grab the Email name you've always wanted before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/
