Forum Discussion

Jeremiah0028's avatar
Jeremiah0028
Copper Contributor
Sep 24, 2024

I keep getting the error code that there are too many arguments for this function

=IF([@[Everything added]]="X", "DONE", (IF(AND([@[TCO Ship Date]]<=TODAY()+3, ([@LAT]="X")), "Order PD", "Order Motors", (IF([@[TCO Ship Date]]<=TODAY()+8, "Order Motors", (IF([@[TCO Ship Date]]<=TODAY()+15, "Order DTI Only", "Wait"))))))))

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 24, 2024

    Jeremiah0028 

    Yes, too many of them on second IF

    =IF( [@[Everything added]]="X",
     "DONE",
  IF( AND([@[TCO Ship Date]]<=TODAY()+3, [@LAT]="X"),
     "Order PD",
     "Order Motors", // one of this is to be removed
   IF( [@[TCO Ship Date]]<=TODAY()+8,
       "Order Motors",
   IF([@[TCO Ship Date]]<=TODAY()+15,
      "Order DTI Only",
       "Wait"))))

Resources