+ Reply to Thread
Results 1 to 9 of 9

Needing Help with IF Formula

  1. #1
    Registered User
    Join Date
    02-03-2023
    Location
    North Dakota, USA
    MS-Off Ver
    Version 2208
    Posts
    4

    Needing Help with IF Formula

    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!

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Needing Help with IF Formula

    Try:

    =IF(LEFT(G6,2)="PL",N6*J6*K6,IFERROR(ROUNDUP(VLOOKUP(G6,SteelTable,2,FALSE)*N6*J6,0),""))

  3. #3
    Registered User
    Join Date
    02-03-2023
    Location
    North Dakota, USA
    MS-Off Ver
    Version 2208
    Posts
    4

    Re: Needing Help with IF Formula

    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?

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Needing Help with IF 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))

  5. #5
    Registered User
    Join Date
    02-03-2023
    Location
    North Dakota, USA
    MS-Off Ver
    Version 2208
    Posts
    4

    Re: Needing Help with IF Formula

    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.
    Attached Files Attached Files
    Last edited by jasbar1; 02-04-2023 at 12:49 PM.

  6. #6
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Needing Help with IF Formula

    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?

  7. #7
    Registered User
    Join Date
    02-03-2023
    Location
    North Dakota, USA
    MS-Off Ver
    Version 2208
    Posts
    4

    Re: Needing Help with IF Formula

    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.

  8. #8
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Needing Help with IF Formula

    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?

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Needing Help with IF Formula

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Needing help to tweak my formula
    By mgianzero in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-31-2022, 06:04 PM
  2. [SOLVED] Needing help with a dynamic formula
    By sbbatti in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-02-2019, 04:39 PM
  3. Needing help on an if than formula
    By midwest trader in forum Excel General
    Replies: 5
    Last Post: 12-05-2016, 07:50 PM
  4. [SOLVED] Needing to set a limit in an IF formula
    By jnelson83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2013, 06:11 AM
  5. [SOLVED] Needing an logical if formula
    By jt1561 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2013, 05:39 PM
  6. Formula needing help with. (IFs, ANDs, ORs)
    By stacey52891 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-09-2013, 10:37 AM
  7. novice needing help on formula
    By jordiman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2009, 08:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1