IF(AND(COUNTIF(R8:R1007,"koso*")>0,COUNTIF(R8:R1007,"kura*")<1,COUNTIF(R8:R1007,"*VGM*")<1),COUNTIF(R8:R1007,"KOSO*")&" BOOKING KOSONG"
IF(AND(COUNTIF(R8:R1007,"koso*")<1,COUNTIF(R8:R1007,"kura*")>0,COUNTIF(R8:R1007,"*VGM*")<1),COUNTIF(R8:R1007,"Kura*")&" BOOKING MASIH KURANG"
IF(AND(COUNTIF(R8:R1007,"koso*")<1,COUNTIF(R8:R1007,"kura*")<1,COUNTIF(R8:R1007,"*VGM*")>0),COUNTIF(R8:R1007,"*VGM*")&" BOOKING VGM PROBLEM"
IF(AND(COUNTIF(R8:R1007,"koso*")>0,COUNTIF(R8:R1007,"kura*")>0,COUNTIF(R8:R1007,"*VGM*")<1),COUNTIF(R8:R1007,"KOSO*")&" BOOKING KOSONG"&" dan "&COUNTIF(R8:R1007,"KURA*")
IF(AND(COUNTIF(R8:R1007,"koso*")<1,COUNTIF(R8:R1007,"kura*")>0,COUNTIF(R8:R1007,"*VGM*")>0),COUNTIF(R8:R1007,"KURA*")&" BOOKING MASIH KURANG"&" dan "&COUNTIF(R8:R1007,"*VGM*")&" BOOKING VGM PROBLEM")
IF(AND(COUNTIF(R8:R1007,"koso*")>0,COUNTIF(R8:R1007,"kura*")<1,COUNTIF(R8:R1007,"*VGM*")>0),COUNTIF(R8:R1007,"KOSO*")&" BOOKING KOSONG"&" dan "&COUNTIF(R8:R1007,"*VGM*")&" BOOKING VGM PROBLEM")
IF(AND(COUNTIF(R8:R1007,"koso*")<1,COUNTIF(R8:R1007,"kura*")<1,COUNTIF(R8:R1007,"*VGM*")<1),""
IF(AND(COUNTIF(R8:R1007,"koso*")>1,COUNTIF(R8:R1007,"kura*")>1,COUNTIF(R8:R1007,"*VGM*")>1),COUNTIF(R8:R1007,"KOSO*")&" BOOKING KOSONG"&" dan "&COUNTIF(R8:R1007,"KURA*")&" BOOKING MASIH KURANG"&" dan "&COUNTIF(R8:R1007,"*VGM*")&" BOOKING VGM PROBLEM"
Bookmarks