Question

Jika B4 besar dari 100,maka akan diberi keterangan "Door Prize"selain itu akan diberi keterangan "Kacian Deh Lo" maka bentuk rumusnya?

Answer 1

bentuk rumunya begini
=IF(B4>100,”=,”DOOR PRIZE”,”KACIHAN DEH LO”)
=IF(B4>=100,”=,”DOOR PRIZE”,”KACIHAN DEH LO”)
=IF(B4>100,”DOOR PRIZE”,”KACIHAN DEH LO”)
=IF(B4<>100,”DOOR PRIZE”,”KACIHAN DEH LO”)
=IF(B4<=100,”DOOR PRIZE”,”KACIHAN DEH LO”)