+ Reply to Thread
Results 1 to 3 of 3

how to find missing "false" parts of nested IF formulas

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    644

    how to find missing "false" parts of nested IF formulas

    I'm using the following formula in a workbook. As you see it uses multiple IF formulas along with some AND formulas. Is there a "hack" or other methods I can use when building these formulas so that I can see the structure? The approach I want is to say "if the first IF statement is false, go on to the next IF statement"

    But as I hover my mouse over the formula I see that in the final ))))))) there are places where the formula is asking for "value if false."


    Please Login or Register  to view this content.
    Thanks for looking at this.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,158

    Re: how to find missing "false" parts of nested IF formulas

    Use notepad to rearrange lines. Works for me.
    Capture.JPG
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: how to find missing "false" parts of nested IF formulas

    If you click in the area between each of the close brackets, you will see the help bar moves to position under the relevant IF statement.

    Untitled.jpg

+ 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. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] How to analyze missing "If false" parts of nested IF formulas
    By jrtaylor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2018, 12:01 PM
  3. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  4. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  5. Replies: 7
    Last Post: 05-13-2006, 05:02 PM
  6. [SOLVED] If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM
  7. IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 01:05 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