Forum Discussion

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]]<=TOD...

excel

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"))))