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
