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 |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |