HI CAN SOMEONE HELP ME ON MY CODE
IFS(AND([CARS]= “Y”,[LEAST AGE OF VEHICLE] = “Y”, [REFRIGERATOR]= “Y”,[WASHING MACHINE]= “Y”,[ELECTRICITY]=“Y”,[RUNNING WATER/ MOTORIZED WATER PUMPWITH PLUMBING FACILITIES]=“Y”,[TOTAL POINTS] >= 30),“AB”,
IFS([CARS]= “Y”,[LEAST AGE OF VEHICLE] = “Y”,[REFRIGERATOR]= “Y”,[WASHING MACHINE]= “Y”,[ELECTRICITY]=“Y”,[RUNNING WATER/ MOTORIZED WATER PUMPWITH PLUMBING FACILITIES]=“Y”,[TOTAL POINTS] = 29),“C1”)
WHEN I PUT THIS CODE IM ALWAYS HAVING AN ERROR
“IFS function is used incorrectly:Inputs to IFS() must be one or more condition-value pairs.”
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |