+ Reply to Thread
Results 1 to 3 of 3

"FALSE" result outcome problem

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    "FALSE" result outcome problem

    I have the following formula that works however I get a “FALSE” outcome when it doesn’t have the right answer.
    Is there a way to remove the FALSE outcome with a blank outcome, i.e. “”


    Please Login or Register  to view this content.

    Thanks for your help.
    Last edited by Christopherdj; 08-04-2014 at 09:01 PM.

  2. #2
    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,946

    Re: "FALSE" result outcome problem

    Try this (untested)...
    =IF(OR($L4={"L","P"}),"",IF($L4="S",VLOOKUP(H4,Arrays!B:E,3,0)*IF($A4="WPA",'HESG Funding'!$C$4,1),""))

    Also, I took the liberty if simplifying it slightly
    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

  3. #3
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: "FALSE" result outcome problem

    Thanks, but whilst it removed the problem, your simplification did not meet the criteria for the end results.
    I did however manage a solution

    Please Login or Register  to view this content.
    if there is an easier way to reduce the code it would be most helpful, but it works as the false was coming from a Blank cell at L4 which has been rectified by adding the if to the front.
    thanks for the assistance.
    Last edited by Christopherdj; 08-04-2014 at 08:58 PM.

+ 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. World Cup "OR" formula shows TRUE and FALSE to same result?
    By jbelliot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2014, 06:49 AM
  2. Why is my Formula result = "True" rather than "False"
    By Mike Burns in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2012, 10:14 AM
  3. compare two excel sheets using macros and display the result in "true" or "false"
    By gayunana01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 07:21 AM
  4. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  5. Replies: 7
    Last Post: 05-13-2006, 05:02 PM

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