+ Reply to Thread
Results 1 to 5 of 5

Formula indicator in cells???

  1. #1
    Vasant Nanavati
    Guest

    Re: Formula indicator in cells???

    Tools | Options | Error Checking | Settings | Enable Background Error
    Checking

    Clear the checkbox.

    ---------

    Vasant

    "Bob Newman" <[email protected]> wrote in message
    news:cn4ue.5183$up5.4912@lakeread02...
    > Excel 2003
    >
    > I have several cells that contain IF formulas in them. If it makes any
    > difference they are formatted to show nothing if a referenced cell is
    > blank
    > i.e. (=IF(A7="","","Widget"). Regarding the appearance of these cells,
    > they
    > have a small indicator in the upper left (similar to the indictor to shows
    > that a cell contains a note). I do not want this visible (whatever it
    > is).
    > Why is it there? How do I get rid of it?
    > --
    >
    > Thanks in advance... Bob
    >
    >




  2. #2
    Bob Newman
    Guest

    Re: Formula indicator in cells???

    Thanks.

    Bob

    "Vasant Nanavati" <vasantn AT aol DOT com> wrote in message
    news:[email protected]...
    > Tools | Options | Error Checking | Settings | Enable Background Error
    > Checking
    >
    > Clear the checkbox.
    >
    > ---------
    >
    > Vasant
    >
    > "Bob Newman" <[email protected]> wrote in message
    > news:cn4ue.5183$up5.4912@lakeread02...
    > > Excel 2003
    > >
    > > I have several cells that contain IF formulas in them. If it makes any
    > > difference they are formatted to show nothing if a referenced cell is
    > > blank
    > > i.e. (=IF(A7="","","Widget"). Regarding the appearance of these cells,
    > > they
    > > have a small indicator in the upper left (similar to the indictor to

    shows
    > > that a cell contains a note). I do not want this visible (whatever it
    > > is).
    > > Why is it there? How do I get rid of it?
    > > --
    > >
    > > Thanks in advance... Bob
    > >
    > >

    >
    >




  3. #3
    Bob Newman
    Guest

    Formula indicator in cells???

    Excel 2003

    I have several cells that contain IF formulas in them. If it makes any
    difference they are formatted to show nothing if a referenced cell is blank
    i.e. (=IF(A7="","","Widget"). Regarding the appearance of these cells, they
    have a small indicator in the upper left (similar to the indictor to shows
    that a cell contains a note). I do not want this visible (whatever it is).
    Why is it there? How do I get rid of it?
    --

    Thanks in advance... Bob



  4. #4
    Vasant Nanavati
    Guest

    Re: Formula indicator in cells???

    Tools | Options | Error Checking | Settings | Enable Background Error
    Checking

    Clear the checkbox.

    ---------

    Vasant

    "Bob Newman" <[email protected]> wrote in message
    news:cn4ue.5183$up5.4912@lakeread02...
    > Excel 2003
    >
    > I have several cells that contain IF formulas in them. If it makes any
    > difference they are formatted to show nothing if a referenced cell is
    > blank
    > i.e. (=IF(A7="","","Widget"). Regarding the appearance of these cells,
    > they
    > have a small indicator in the upper left (similar to the indictor to shows
    > that a cell contains a note). I do not want this visible (whatever it
    > is).
    > Why is it there? How do I get rid of it?
    > --
    >
    > Thanks in advance... Bob
    >
    >




  5. #5
    Bob Newman
    Guest

    Re: Formula indicator in cells???

    Thanks.

    Bob

    "Vasant Nanavati" <vasantn AT aol DOT com> wrote in message
    news:[email protected]...
    > Tools | Options | Error Checking | Settings | Enable Background Error
    > Checking
    >
    > Clear the checkbox.
    >
    > ---------
    >
    > Vasant
    >
    > "Bob Newman" <[email protected]> wrote in message
    > news:cn4ue.5183$up5.4912@lakeread02...
    > > Excel 2003
    > >
    > > I have several cells that contain IF formulas in them. If it makes any
    > > difference they are formatted to show nothing if a referenced cell is
    > > blank
    > > i.e. (=IF(A7="","","Widget"). Regarding the appearance of these cells,
    > > they
    > > have a small indicator in the upper left (similar to the indictor to

    shows
    > > that a cell contains a note). I do not want this visible (whatever it
    > > is).
    > > Why is it there? How do I get rid of it?
    > > --
    > >
    > > Thanks in advance... Bob
    > >
    > >

    >
    >




+ 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