+ Reply to Thread
Results 1 to 2 of 2

Formula resulting in FALSE

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007 to 2013
    Posts
    35

    Formula resulting in FALSE

    I have the formula sa below, and cant work why its coming out as false when its parent worksheet was a similar formula with only one additional change made to it fro this one.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Any advice greatly appreciated

    Tim

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formula resulting in FALSE

    It's returning FALSE because 1 or more of the IF conditions is FALSE.

    I'd suggest using the "Evaluate Formula" tool on the Formulas Tab to step through the formula and see where it's getting the FALSE from.

    I would have to guess it's the 2nd IF
    IF($V12=""

    Because that's the only one that you haven't specified a 'do this if false' part.

+ 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. Excel 2007 : sumifs formula resulting in 0
    By RichGold in forum Excel General
    Replies: 4
    Last Post: 06-14-2011, 01:49 AM
  2. Subtracting cells resulting in FALSE
    By Kmac in forum Excel General
    Replies: 2
    Last Post: 04-02-2010, 05:55 AM
  3. [SOLVED] Formula resulting in 0
    By adodson in forum Excel General
    Replies: 10
    Last Post: 05-31-2006, 02:25 PM
  4. Formula entered in VBA resulting in #Name?
    By Kobayashi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2005, 06:55 AM
  5. [SOLVED] If resulting in False when it is actually true
    By Papa Jonah in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-18-2005, 12:06 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