A special value displayed in a cell when Excel cannot correctly calculate a formula.
Попробовать с ИИError values are built-in indicators such as #REF!, #VALUE!, or #N/A that signal a specific issue within a formula or data reference. They prevent incorrect calculations from propagating through a workbook by alerting the user that the formula logic or input data requires correction.
If you attempt to divide a number by zero, Excel displays the #DIV/0! error value.
You can use the IFERROR function to wrap your formula and return a custom value, such as an empty string or zero, instead of the error.