ExcelBanter - Hide Value of Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hide Value of Cell (https://www.excelbanter.com/excel-discussion-misc-queries/2465-hide-value-cell.html)

Mark

Hide Value of Cell

Hello,

I have a cell (c) with this formula: =(a2/b2)-1.005. I
want to hide the #DIV/0! that appears in the cell when
there is no data in a2 or b2. Is this possible? Thanks
in advance for your help.

Mark

Art

Try:

=IF(B2<0,(A2/B2)-1.005,"")

Art

"Mark" wrote:

Hello,

I have a cell (c) with this formula: =(a2/b2)-1.005. I
want to hide the #DIV/0! that appears in the cell when
there is no data in a2 or b2. Is this possible? Thanks
in advance for your help.

Mark

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