" Life is not a problem to be solved but a reality to be experienced! "
© Copyright 2013 - 2024 KUDO.TIPS - All rights reserved.
2.=if(E11="AB",500000,300000)
3.=if(F11="Melati",500000,300000)
4.=if(F11="Melati","Handuk","Sandal")
5.=if(E11="AB","AC","Kipas Angin")
6.=if(J11="AC","AB","Ekonomi")
Semoga Membantu :)
CMIIW
kamar adalah =IF(B11="AB";"melati";"mawar")
harga adalah =IF(B11="AB";500000;300000)
pajak =IF(C11="melati";500000;300000)
bonus =IF(C11="melati";"handuk";"sandal")
fasilitas =IF(B11="AB";"AC";"Kipas angin")
keterangan =IF(G11="AC";"AB";"ekonomi")