+ Reply to Thread
Results 1 to 4 of 4

The formulated cell appear blank

  1. #1
    Forum Contributor
    Join Date
    08-30-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    141

    Question The formulated cell appear blank

    Hi all Excel gurus

    I wonder if excel can make the formulated cell keep blank. For example:

    cell A1: =A2 will appear 0 if there is no value or text in A2 but what i want is that A1 will be blank if there is no value in A2. I do not want the 0 appear in A1.

    I know, maybe VBA can do it but i'm not good in it.

    I will appreciate it if you guys help me.

    Thanks

    Imran

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: The formulated cell appear blank

    Hello

    File
    option
    advanced
    scroll down to --->display option for this worksheet

    uncheck --->"Show a zero.... "

    or
    maybe an if..
    =IF(A1="","",A1) -????
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Contributor
    Join Date
    08-30-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    141

    Re: The formulated cell appear blank

    owh thank you vlady. I dont know it simple like that. haha. thank you very much!

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: The formulated cell appear blank

    Your welcome!!


    regards,
    vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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