Forum Discussion

YHKYH's avatar
YHKYH
Copper Contributor
Apr 30, 2023

Formula for checkbox

Hi, can anyone help with this checkbox with 3 condition. both "blank","pending","done" is a drop down list selection

IF cell"A2" is "blank" return NIL

IF cell"A2" is  "pending" check whether "A4" or "A5" isblank, if isblank return "pending" else return "check" 

IF cell"A2" is "done" check 

Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Apr 30, 2023

    YHKYH You may try-

    =IF(A2="","",IF(A2="pending",IF(AND(A4="",A5=""),"pending",""),"Check"))

Resources