Fungsi Logika

FUNGSI LOGIKA

1. If tunggal
=if(logical test, value if true, value if false)
contah:
=if(a>5,"BIRU","MERAH")
2. If and
=if(and(logical test, logical test 1), value if true, value if false)
contoh:
=if(and(A2="Kuning","B2"="

Jeruk"),"Lokal","Impor")
3.If or
=if(or(logical test,logical test 1), value if true, value if false)
contoh:
=if(or(A2="Kuning", B2="Jeruk"),"Lokal","Impor")