+ Reply to Thread
Results 1 to 4 of 4

Upgrade formula to add one more variable

  1. #1
    Forum Contributor Webbers's Avatar
    Join Date
    09-06-2005
    Location
    Poinciana, FL
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    337

    Upgrade formula to add one more variable

    I wrote a formula, and it works perfectly, only now I have to integrate one more factor into it, and I cannot seem to get it to work. My formula is (which resides in cell B40):

    =IFERROR(IF(VLOOKUP($E1,Calc_Table,22,FALSE)=0,0,VLOOKUP($E1,Calc_Table,22,FALSE)),"-")

    I need to add in if the value from the "Calc_Table" (column 22) happens to be 2 or greater, than I need "-" to display in the cell. I was able to get it to work in the first cell, but when the value was 1, it still displayed "-", which is wrong. I know the answer is something simple, I just cannot figure it out, any help is appreciated. Thanks so much!
    ~*~ Sherry ~*~
    Poinciana, FL

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Upgrade formula to add one more variable

    Maybe

    =IFERROR(IF(VLOOKUP($E1,Calc_Table,22,FALSE)=0,0,IF(VLOOKUP($E1,Calc_Table,22,FALSE)>=2,"-",VLOOKUP($E1,Calc_Table,22,FALSE))),"-")

  3. #3
    Forum Contributor Webbers's Avatar
    Join Date
    09-06-2005
    Location
    Poinciana, FL
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    337

    Re: Upgrade formula to add one more variable

    Cutter----
    That works PERFECTLY!!!! My attempt was VERY close, but I don't believe I had the 3 closing parenthesis near the end. Thanks so very much!!!!!

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Upgrade formula to add one more variable

    You're welcome. Thanks for the 'star tap'.
    Last edited by Cutter; 05-09-2012 at 11:41 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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