+ Reply to Thread
Results 1 to 6 of 6

Formula displays "FALSE" instead of what was designated. Why?

  1. #1
    Registered User
    Join Date
    07-12-2021
    Location
    Missouri, USA
    MS-Off Ver
    365
    Posts
    3

    Formula displays "FALSE" instead of what was designated. Why?

    I have a formula I'm trying to construct which will look at a cell and then search for a term in another cell based on what populates the first cell. If there isn't a match between the two a message will display saying, "Verify Selections". Instead of displaying the message, False is the only displayed text.

    For the formula, displaying nothing means the combination of the two choices match and no further action is required, and the message is only displayed when the two selected options do not match.

    I have many data validation cells that piggy back off the previous and I would like to create a warning if the series of selected cells do not match as they should.

    It will work correctly in some combinations, but not all.

    Sample workbook attached.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,147

    Re: Formula displays "FALSE" instead of what was designated. Why?

    Change your DV to

    =INDIRECT(TRIM(SUBSTITUTE(B2,"Things","")))

    and named ranges to "Flat" and "Round" (Proper not Upper case)

    Then why do you need your validation test ?

  3. #3
    Registered User
    Join Date
    07-12-2021
    Location
    Missouri, USA
    MS-Off Ver
    365
    Posts
    3

    Re: Formula displays "FALSE" instead of what was designated. Why?

    My apologies for not being specific enough.

    In the case you presented above, doesn't help when someone selects "Round Things" and then chooses "basketball", and then inadvertently chooses "Flat Things" and does not reselect something from the "Flat Things" list.

    I've attached a screenshot of what happens.
    Attached Images Attached Images
    Last edited by Jfinnell; 07-12-2021 at 03:43 PM. Reason: Image didn't post

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,147

    Re: Formula displays "FALSE" instead of what was designated. Why?

    Your formula

    =IF(B2="Round Things",IF(ISNUMBER(SEARCH("ball",B3)),"","verify Selection"),IF(B2="Flat Things",IF(ISNUMBER(SEARCH("flat",B3)),"","Verify Selections")))

    You will het this "warning message" each time you change B2 (correctly for the next valid selection): is that what you want?
    Last edited by JohnTopley; 07-12-2021 at 04:05 PM.

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,147

    Re: Formula displays "FALSE" instead of what was designated. Why?

    Look at "Formulas" ===>"Evaluate Formula": very useful for identifying errors/missing conditions.

  6. #6
    Registered User
    Join Date
    07-12-2021
    Location
    Missouri, USA
    MS-Off Ver
    365
    Posts
    3

    Re: Formula displays "FALSE" instead of what was designated. Why?

    Thanks JohnTopley. I figured I was missing something easy.

+ 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. Formula for "true" or "false" based on whether or not a row has a color filled cell
    By the_red_engine in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-04-2021, 10:24 PM
  2. IF formula displays "FALSE" as result
    By cyrano3790 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-14-2019, 09:12 AM
  3. Replies: 7
    Last Post: 04-11-2013, 12:46 AM
  4. 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
  5. Formula is returning "FALSE" instead of "" (blank)
    By wvpersephone13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2011, 04:31 PM
  6. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  7. Replies: 7
    Last Post: 05-13-2006, 05:02 PM

Tags for this Thread

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