filmov
tv
Quickly Replace Formulas Error Messages With Zero, Blank Cells, Or Text
![preview_player](https://i.ytimg.com/vi/G7JXoJcjvEo/sddefault.jpg)
Показать описание
Sometimes the formula may produce error message in Excel. For example, in this formula =A1/B1, if B1 is empty or contains 0, the formula will display a #DIV/0 error. Is there any way to make those error messages clearly readable with some customizing text or others? Kutools for Excel's Error Condition Wizard can quickly add error condition to a formula or group of formulas to display the formulas that produce errors with the 0(zero), a custom message, blank cells, cell reference, etc.