我想在此语句末尾添加if(al2="", today()-ak2,"not enough info to calc)
,但我收到“参数太多”消息。有人能帮我吗?我认为这可能是括号问题:
=IFERROR(IF(OR(AI2="",AH2=""),0,IF(IFERROR(SEARCH("lcl",BG2),0)=0,IF(BR2<>"","",IF(OR(IFERROR(SEARCH("port of ",E2),0)<>0,IFERROR(SEARCH("Dgf elp ",E2),0)<>0,IFERROR(SEARCH("energy",E2),0)<>0,IFERROR(SEARCH("silt ",E2),0)<>0,IFERROR(SEARCH("Delivered to ei ",E2),0)<>0,IFERROR(SEARCH({"Delivered","Confirmed","Appt","Completed","Ramp"},E2),0)<>0),IF(AW2<>"",IF(BF2<>"",BF2-AW2,TODAY()-AW2),IF(AQ2<>"",IF(BF2<>"",BF2-AQ2,TODAY()-AQ2),IF(AT2<>"",IF(BF2<>"",BF2-AT2,TODAY()-AT2),IF(BF2<>"",BF2-AL2,TODAY()-AL2)))),"")),"LCL")),0)