ExcelBanter - Formula Error Message

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

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

- - Formula Error Message (https://www.excelbanter.com/excel-discussion-misc-queries/16753-formula-error-message.html)

Chambersteacher

Formula Error Message

Is there a way to not have the formula error message DIV/0! display in a cell
and still keep the formula?

Myrna Larson

If the formula is, e.g., =a1/b1 change it to =IF(B1=0,"",A1/B1)

On Tue, 8 Mar 2005 20:01:03 -0800, Chambersteacher
wrote:

Is there a way to not have the formula error message DIV/0! display in a cell
and still keep the formula?

All times are GMT +1. The time now is 12:55 PM.