Need help with syntax

dgardnerman

Board Regular
Joined
Jul 17, 2014
Messages
73
I'm trying to add some features to an existing formula so that if G/454= "ALLTHRD" "HDD_STUDS" "THRDD_STUDS" "DEFORMBARS" or "REBAR" are used in the drop down window, the target cell M/454 will display a blank and multiply O/454 by E/454.

Here is my current syntax and link to screenshot:

=IFERROR(IF(A454<>"x","",IF(G454="BOLT","",IF(I454="","",IF(G454="PLATE",(I454*K454/144*L454)*E454,IF(G454="GRATING","",IF(G454="DECKING","",(I454/12*L454)*E454)))))),"")

https://www.dropbox.com/s/r4v9nd4byq679bh/Screen Shot 2018-10-31 at 9.10.33 AM.png?dl=0
 
Last edited:

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Not sure what you mean by display a blank AND multiply.

Sounds like an OR statement may help though.

=IF(OR(
G454="ALLTHRD",G454="HDD_STUDS",G454="THRDD_STUDS",G454="DEFORMBARS",G454="REBAR"),true,false)
 
Upvote 0
You can also use
=IF(OR(G454={"ALLTHRD","HDD_STUDS","THRDD_STUDS","DEFORMBARS","REBAR"}),TRUE,FALSE)

But this
the target cell M/454 will display a blank and multiply O/454 by E/454.
makes no sense, how can M454 be blank & multiply 2 cells?
 
Upvote 0
My shallow thinking was the cell could go about it's business with the original formula, and then we could add more IF to the equation to do something else.
I think I can make it work if I have this formula calculate in a cell separate from the target cell. I'll use an IF in the target cell to calculate the TRUE or FALSE equation.
 
Upvote 0
You can add it in there just like your other IFs, just isn't clear what you want the result to be. Just change the TRUE to reflect what you want to happen.

=IFERROR(IF(A454<>"x","",IF(G454="BOLT","",IF(I454="","",IF(G454="PLATE",(I454*K454/144*L454)*E454,IF(G454="GRATING","",IF(G454="DECKING","",IF(OR(G454={"ALLTHRD","HDD_STUDS","THRDD_STUDS","DEFORMBARS","REBAR"}),TRUE,(I454/12*L454)*E454))))))),"")
 
Last edited:
Upvote 0
Not typing out all the words so you'll need to add to:

=IF(OR(A461="",E461="",M461="",O461=""),"",IF(AND(A461="x",OR(G641 ={"BOLT","DECKING"})),E461*O461,IF(AND(A461="x",OR(G641 ={"ANGLE","BAR"})),(E461*M461)*O461,"")))
 
Upvote 0
hmmm...I see the logic when I run through it, but it's returning a blank whether it's from the bolt selection side or the angle selection side. Not sure where the tickler is?
 
Upvote 0

Forum statistics

Threads
1,223,532
Messages
6,172,878
Members
452,486
Latest member
standw01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top