Proper use of IF( AND( OR(

[dgardnerman]

I have a monster of a syntax and I can't figure out how to incorporate the function below into the existing string.

I want U24 to calculate SUM(S24,T24)*P24*E24 IF("DECKING" populates G24

Here is the syntax:

[FONT=&quot]=IFERROR(IF(AND(E24=0,R24=0,T24=0),"",IF(AND(A24="x",OR(G24={"Plug","bolt","grating","studs-thd","studs-hdd","deformbars","allthrd","rebar"})),SUM(S24,T24)*E24,IF(AND(A24="x",OR(G24={"Angle","Bar","WF","Channel","Hss","Pipe","Plate"})),(R24*T24),""))),"")

Here is the spreadsheet for reference (turn on objects to see drop-downs):

https://www.dropbox.com/s/85z3rqub1563rn5/2 - Template In Progress.xlsx?dl=0

[/FONT]

 

[dgardnerman]

I have a monster of a syntax and I can't figure out how to incorporate the function below into the existing string.

I want U24 to calculate SUM(S24,T24)*P24*E24 IF("DECKING" populates G24

Here is the syntax:

=IFERROR(IF(AND(E24=0,R24=0,T24=0),"",IF(AND(A24="x",OR(G24={"Plug","bolt","grating","studs-thd","studs-hdd","deformbars","allthrd","rebar"})),SUM(S24,T24)*E24,IF(AND(A24="x",OR(G24={"Angle","Bar","WF","Channel","Hss","Pipe","Plate"})),(R24*T24),""))),"")

Here is the spreadsheet for reference (turn on objects to see drop-downs):

https://www.dropbox.com/s/85z3rqub1563rn5/2 - Template In Progress.xlsx?dl=0

I love it when I can respond to my own posts...
I figured it out...

[FONT=&quot]=IFERROR(IF(AND(E24=0,R24=0,T24=0),"",IF(G24="decking",SUM(S24,T24)*P24,IF(AND(A24="x",OR(G24={"Plug","bolt","grating","studs-thd","studs-hdd","deformbars","allthrd","rebar"})),SUM(S24,T24)*E24,IF(AND(A24="x",OR(G24={"Angle","Bar","WF","Channel","Hss","Pipe","Plate"})),(R24*T24),"")))),"")[/FONT]