+ Reply to Thread
Results 1 to 2 of 2

=AND() not working as expected. Two true functions don't give true result

  1. #1
    Registered User
    Join Date
    03-30-2018
    Location
    Nevada
    MS-Off Ver
    2016/365
    Posts
    2

    =AND() not working as expected. Two true functions don't give true result

    I have this function for conditional formatting and it works and colors my cells depending on of the blank state of the cell in the first row relative to my current column:

    =ISBLANK( INDIRECT( ADDRESS( ROW(), 1, 1, FALSE ), FALSE ) )

    If I try to do this exact test twice and use the AND function, the result is FALSE:

    =AND( ISBLANK( INDIRECT( ADDRESS( ROW(), 1, 1, FALSE ), FALSE ) ), ISBLANK( INDIRECT( ADDRESS( ROW(), 1, 1, FALSE ), FALSE ) ) )

    The AND() function should be getting a TRUE result from the ISBLANK function returning TRUE in both cases (they are the identical test that worked alone above).

    What am I missing? I have not used excel much but this seems really strange to me.

    BTW, I have my cell references configured for RC notation (row, column).

  2. #2
    Registered User
    Join Date
    03-30-2018
    Location
    Nevada
    MS-Off Ver
    2016/365
    Posts
    2

    Re: =AND() not working as expected. Two true functions don't give true result

    I stuck the second formula into a cell in a new blank worksheet and the cell shows "TRUE" so it is just a problem with conditional formatting. How strange.

+ 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. the TRUE expected principal - Loan Portfolio
    By TheDunce in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2018, 10:22 AM
  2. [SOLVED] Give value true if a text can be find on a range
    By Spikyd in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-08-2017, 05:52 AM
  3. Replies: 4
    Last Post: 06-21-2017, 10:33 AM
  4. Trimmed mean doesn't give expected result
    By Winton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-03-2012, 06:31 AM
  5. IF help to give value if true Shipping info
    By Joelinnh in forum Excel General
    Replies: 2
    Last Post: 08-06-2011, 03:26 PM
  6. Formula that will give me True or False results
    By Reenee in forum Excel General
    Replies: 2
    Last Post: 02-02-2009, 10:36 AM
  7. [SOLVED] Need a property that will give me true if a value is close
    By havocdragon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2005, 06:06 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