Re: How to make multiple ifs

iengage_appshee · 06-17-2021 11:17 PM

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.”

Steve