Adding IF Formula with 2 conditions to another formula

[Rosser14]

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

 

[6StringJazzer]

Your first formula is very long and complicated. Can you describe what it does? I need to understand how the result of the second formula is supposed to fit in.

I am also not clear on how you are trying to modify it using the second formula.

if both are met, then it will concatenate "10 Ton"

Concatenate it to what? You cannot concatenate a single thing.

In the second formula, you only have the result for the TRUE case. Also you are just using a single string in CONCATENATE; that function is used to join together more than one string. So the result of your second formula is going to be either

10 Ton

or

FALSE

And I don't know how that result is supposed to fit into your first formula.