Fungsi IF dengan 5 Kriteria
Berikut pernyataan logika dengan lima kriteria.
Ketiklah data berikut ini usahakan cells berisi data tepat berada pada cells
seperrti contoh agar memudahkan kita mengetahui hasilnya.
Pada bagian baris Bonus ketiklah rumus berikut
ini :
Pada cells D4
=IF(C4>=10000000," TV LCD 17 Inci ",IF(C4>=5000000,"
Diskon 30%",IF(C4>=3000000,"Jam
Tangan",IF(C4>=1000000,"Jam
Dinding",IF(C4<=10000000," - " )))))
Pada cells D5
=IF(C5>=10000000," TV LCD 17 Inci
",IF(C5>=5000000," Diskon 30%",IF(C5>=3000000,"Jam
Tangan",IF(C5>=1000000,"Jam Dinding",IF(C5<=10000000,"
- " )))))
Pada cells D6
=IF(C6>=10000000," TV LCD 17 Inci
",IF(C6>=5000000," Diskon 30%",IF(C6>=3000000,"Jam
Tangan",IF(C6>=1000000,"Jam
Dinding",IF(C6<=10000000," - " )))))
Pada cells D7
=IF(C7>=10000000," TV LCD 17 Inci
",IF(C7>=5000000," Diskon 30%",IF(C7>=3000000,"Jam
Tangan",IF(C7>=1000000,"Jam
Dinding",IF(C7<=10000000," - " )))))
Pada cells D8
=IF(C8>=10000000," TV LCD 17 Inci
",IF(C8>=5000000," Diskon 30%",IF(C8>=3000000,"Jam
Tangan",IF(C8>=1000000,"Jam
Dinding",IF(C8<=10000000," - " )))))
Pada cells D9
=IF(C9>=10000000," TV LCD 17 Inci
",IF(C9>=5000000," Diskon 30%",IF(C9>=3000000,"Jam
Tangan",IF(C9>=1000000,"Jam
Dinding",IF(C9<=10000000," - " )))))
Berikut penulisan rumus pada cells yang benar.
Gambar
Pengetikan rumus
Gambar Hasil akhir
Tidak ada komentar:
Posting Komentar