ExcelBanter - How to get a cell with a zero errorto show the cell as blank

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to get a cell with a zero errorto show the cell as blank (https://www.excelbanter.com/excel-worksheet-functions/93413-how-get-cell-zero-errorto-show-cell-blank.html)

jsunshine

How to get a cell with a zero errorto show the cell as blank

Roger Govier

How to get a cell with a zero errorto show the cell as blank

Hi

Do you mean something like
=IF(ISERROR(your_formula),"",your_formula)

Substitute the formula you have that is giving the divide by zero error
for "your_formula"

--
Regards

Roger Govier

"jsunshine" wrote in message
...

jsunshine

How to get a cell with a zero errorto show the cell as blank

Thank you! It worked perfectly.

"Roger Govier" wrote:

Hi

Do you mean something like
=IF(ISERROR(your_formula),"",your_formula)

Substitute the formula you have that is giving the divide by zero error
for "your_formula"

--
Regards

Roger Govier

"jsunshine" wrote in message
...

All times are GMT +1. The time now is 05:51 AM.