If function too many arguments error

[wells]

How to solve the error in below formula.. ??

$S2=”Billable Only”,”BILLABLE ONLY” when inserted in formula shows error. Rest of the formula works fine.

=IFS($V2="YBWR","What",ISNUMBER($Y2),"Fully Delivered",$S2=”Billable Only”,”BILLABLE ONLY”,AND(ISBLANK($Y2),NOT(ISBLANK($AA2))),"Under shipment",AND(ISBLANK($Y2),ISBLANK($AA2),ISNUMBER($N2)),"Under packing",AND(ISBLANK($Y2),ISBLANK($AA2),ISBLANK($N2)),TEXT(WEEKNUM($W2),"W00"))

 

[RoryA]

You need to replace the curly quotes with normal quotes:

=IFS($V2="YBWR","What",ISNUMBER($Y2),"Fully Delivered",$S2="Billable Only","BILLABLE ONLY",AND(ISBLANK($Y2),NOT(ISBLANK($AA2))),"Under shipment",AND(ISBLANK($Y2),ISBLANK($AA2),ISNUMBER($N2)),"Under packing",AND(ISBLANK($Y2),ISBLANK($AA2),ISBLANK($N2)),TEXT(WEEKNUM($W2),"W00"))