+ Reply to Thread
Results 1 to 3 of 3

Change a False to a blank cell

  1. #1
    Registered User
    Join Date
    09-11-2014
    Location
    Norwich, England
    MS-Off Ver
    2010
    Posts
    7

    Change a False to a blank cell

    Hi there

    I am trying to change my formula so that rather than a False message the cell is Blank

    how can I go about doing this? the original formula is

    =IF(AND(B3<>B2,D3<>D2),COUNTIF($G$3:$G$518201,G3))

    I have changed the formula to
    =IFERROR(IF(AND(B3<>B2,D3<>D2),COUNTIF($G$3:$G$518201,G3)),"")

    but this is still not working.

    Any help would be appreciated

    Many thanks
    Ian

  2. #2
    Registered User
    Join Date
    01-04-2013
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Change a False to a blank cell

    You could try this

    =IF(AND(B3<>B2,D3<>D2),COUNTIF($G$3:$G$518201,G3),"")

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Change a False to a blank cell

    Ian-C

    Upload sample workbook with out any confidential data , and show your expected results manually .

    Punnam

+ 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. Return Blank Cell if value is false
    By Cremorneguy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-02-2014, 11:44 PM
  2. [SOLVED] Instead of having FALSE or #N/A leave a cell blank
    By Mr_Nick666 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-11-2013, 06:28 AM
  3. True/False on whether a cell is blank or not
    By krayziez in forum Excel General
    Replies: 1
    Last Post: 06-06-2008, 02:36 PM
  4. [SOLVED] keep cell blank if IF statement is False
    By ruthslaughter in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-25-2005, 09:35 AM
  5. [SOLVED] keep cell blank when false in IF statement
    By ruthslaughter in forum Excel General
    Replies: 2
    Last Post: 11-22-2005, 02:15 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