ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula indicator in cells??? (https://www.excelbanter.com/excel-worksheet-functions/31824-formula-indicator-cells.html)

Bob Newman

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



Vasant Nanavati

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

Clear the checkbox.

---------

Vasant

"Bob Newman" 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





Bob Newman

Thanks.

Bob

"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
Tools | Options | Error Checking | Settings | Enable Background Error
Checking

Clear the checkbox.

---------

Vasant

"Bob Newman" 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








All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com