Needing help with implementing an additional IF function.
Current formula:
=IFERROR(ROUNDUP(VLOOKUP(G6,SteelTable,2,FALSE)*N6*J6,0),"")
Need to Add:
=IF(LEFT(G6,2)="PL",N6*J6*K6,0)
Thank you in advance!
Needing help with implementing an additional IF function.
Current formula:
=IFERROR(ROUNDUP(VLOOKUP(G6,SteelTable,2,FALSE)*N6*J6,0),"")
Need to Add:
=IF(LEFT(G6,2)="PL",N6*J6*K6,0)
Thank you in advance!
Try:
=IF(LEFT(G6,2)="PL",N6*J6*K6,IFERROR(ROUNDUP(VLOOKUP(G6,SteelTable,2,FALSE)*N6*J6,0),""))
Hello Limor_OP,
Thank you for the quick reply and looking into this. Unfortunately, I think the suggestion you gave me has the formula trying to run the multiplication prior to finding or searching the data in the steel table. Is there a way to add this IF function to the back end of the formula?
well.....
maybe like that?
=IF(NOT(ISERROR(ROUNDUP(VLOOKUP(G6,SteelTable,2,FALSE)*N6*J6,0))),ROUNDUP(VLOOKUP(G6,SteelTable,2,FALSE)*N6*J6,0),IF(LEFT(G6,2)="PL",N6*J6*K6,0))
That still did not seem to calculate or change the Plate (PL) based on the different sizing. I have attached the spreadsheet for reference. If you could take a look at it and tell me what you think. The 2 columns that this formula would be on is "P" & "Q".
Thanks again for all your help.
Last edited by jasbar1; 02-04-2023 at 12:49 PM.
OK, so what are you expecting to see if the description starts with 'PL'?
Taking line 6 for example:
the VLOOKUP segment gives the result of '11'
but going by the PL condition you stated the result is '1'
which one is correct?
If the description starts with "PL" then the formula needs to x the length by the width and by the quantity. If description does not start with "PL, then x by just the length and quantity. As you can see line 7 is 1'-0" by 0'-6", meaning the weight and surface area should be half that of line 6.
I hope this makes sense.
and where is the WIDTH, LENGTH, and QUANTITY? which column and tab name?
and what is the VLOOKUP for? why is it looking on the data tab if all the details already exist in the 'Structural Take Off' tab?
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks