I have the following formula:
=IFERROR(IF((SUMPRODUCT(--(NOT(ISERR(SEARCH({"becket","slings","Riser","Varco, Frame","ASD"},'Job Start Page'!$D$30)))))>0),"",IF('Job Start Page'!$B$30="","",CONCATENATE('Job Start Page'!$B$28,"'' ",@IF((IFS($X$186=1,80,'Job Start Page'!$B$27="Singles",45,'Job Start Page'!$B$27="Doubles",90,'Job Start Page'!$B$27="Triples",135)*(('Job Start Page'!$B$33)/2000)<4.25),CONCATENATE("5 ton "),IF((IFS($X$186=1,80,'Job Start Page'!$B$27="Singles",45,'Job Start Page'!$B$27="Doubles",90,'Job Start Page'!$B$27="Triples",135)*(('Job Start Page'!$B$33)/2000)<10),CONCATENATE("10 ton "),CONCATENATE("20 ton "))),"Stabberless Single Joint Elevator ","(",IF('Job Start Page'!$B$29="No","Connection","Coupling")," OD: ",'Job Start Page'!$B$30,"'')"))),"ERROR for SJE")
I want to be able to add the following information but each time that I try to insert it into the formula above, I get the error "You have entered too many arguments. I want the formula to be added in with the conditions that if both are met, then it will concatenate "10 Ton". Any advice?
IF((AND(‘Job Start Page’!$B$1=”BGF”,’Job Start Page’!$B$4>=14),CONCATENATE(”10 Ton”))
=IFERROR(IF((SUMPRODUCT(--(NOT(ISERR(SEARCH({"becket","slings","Riser","Varco, Frame","ASD"},'Job Start Page'!$D$30)))))>0),"",IF('Job Start Page'!$B$30="","",CONCATENATE('Job Start Page'!$B$28,"'' ",@IF((IFS($X$186=1,80,'Job Start Page'!$B$27="Singles",45,'Job Start Page'!$B$27="Doubles",90,'Job Start Page'!$B$27="Triples",135)*(('Job Start Page'!$B$33)/2000)<4.25),CONCATENATE("5 ton "),IF((IFS($X$186=1,80,'Job Start Page'!$B$27="Singles",45,'Job Start Page'!$B$27="Doubles",90,'Job Start Page'!$B$27="Triples",135)*(('Job Start Page'!$B$33)/2000)<10),CONCATENATE("10 ton "),CONCATENATE("20 ton "))),"Stabberless Single Joint Elevator ","(",IF('Job Start Page'!$B$29="No","Connection","Coupling")," OD: ",'Job Start Page'!$B$30,"'')"))),"ERROR for SJE")
I want to be able to add the following information but each time that I try to insert it into the formula above, I get the error "You have entered too many arguments. I want the formula to be added in with the conditions that if both are met, then it will concatenate "10 Ton". Any advice?
IF((AND(‘Job Start Page’!$B$1=”BGF”,’Job Start Page’!$B$4>=14),CONCATENATE(”10 Ton”))