Results 1 to 13 of 13

Ignore If Blank & check multiple cells for equal values

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    17

    Ignore If Blank & check multiple cells for equal values

    Hi

    I have a row of cells with values as 1,2 or blank cells.

    If A2 cell has value 2, B2 cell has blank value & then C2 has value 2, I need true in cell D2. Can we arrive true in cell D2 by using a formula?

    If A2 cell has value 2, B2 cell has blank value & then C2 has value 1, I need false in cell D2.

    Basically, I need the formula to ignore blank cells & check if the cells that have values have equal values or not.

    For example, please see attached file.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How can I make a macro ignore blank cells? - Blank Cells have formulas
    By mz1161 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2013, 08:54 AM
  2. 'All cells equal' check
    By steev_jd in forum Excel General
    Replies: 6
    Last Post: 07-05-2010, 11:20 AM
  3. Check range of cells for multiple values.
    By proepert in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2010, 01:17 AM
  4. Array Function - ignore blank values
    By gillemi in forum Excel General
    Replies: 6
    Last Post: 06-13-2006, 04:10 AM
  5. [SOLVED] how can i ignore blank cells when multiple cells?
    By arash in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2005, 12:40 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