+ Reply to Thread
Results 1 to 2 of 2

how to be "OK with anything" as outcome of "IF ARRAY(x, y) = "

  1. #1
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    how to be "OK with anything" as outcome of "IF ARRAY(x, y) = "

    Hi guys,

    I've got an array in memory where I test if certain array positions return a certain value -

    it's like this :

    Please Login or Register  to view this content.
    The testvalues come from comboboxes that a user fills - however, if the user leaves a combobox blank, I'd like the if statement to be ok with anything as the return of the test value - so any value or nothing at all.

    Can this be done? I tried "*" and "<>" but that didn't work...

    Thanks in advance for any help!
    Please click the * below if this helps

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,082

    Re: how to be "OK with anything" as outcome of "IF ARRAY(x, y) = "

    This doesnt answer your question but

    AND has precedence over OR so this would be interpeted as

    Please Login or Register  to view this content.
    Are you sure this is what you want?
    This looks more like the norm

    Please Login or Register  to view this content.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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: 4
    Last Post: 11-17-2013, 12:05 PM
  2. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  3. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  4. Replies: 7
    Last Post: 05-13-2006, 05:02 PM
  5. 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

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