masa giut ciieeh... padahal q jg pake office 2007 lhooo... ni coba krm contohnya.. (untuk yg errror "=" sy hilangkan).
________________________________
From: hendrik karnadi <hendrikkarn...@yahoo.com>
To: belajar-excel@yahoogroups.com
Sent: Thu, February 18, 2010 2:23:46 PM
Subject: Re: [belajar-excel] IF lebih banyak
Untuk If lebih dari 7, anda harus pakai Excel 2007.
Salam,
Hendrik Karnadi
________________________________
From: Belajar Exel <belajar.exel@ yahoo.com>
To: belajar-excel@ yahoogroups. com
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
________________________________
New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
IF lebih banyak.xls
Description: MS-Excel spreadsheet
