How Excel hides error values

[savid]

有一个问题让我很困惑。如图1所示，当我在正常操作中设置除法公式时，显示错误值。但是有一天我在做表格的时候，如图2和图3所示，我发现它不会显示错误的值和公式。当我填写前两个值时，它会自动为我计算结果的值。所以我的问题是这是一个错误还是在哪里可以找到该功能？不加其他公式可以实现吗？

 

[Joe4]

（通过谷歌翻译回答这个）。 欢迎来到董事会！ 尝试用以下内容替换您当前的公式，如果单元格 B7 中有数字，它只会返回计算（否则它不会返回任何内容）：

=IF(B7<>0,C7/B7,"")

 

[Greg Truby]

（我不会说中文。所以，我希望谷歌翻译得好。）
您始终可以使用 IFERROR() 函数来抑制错误消息。
例子：

=IFERROR(A1/B1,"")
=IFERROR(A1/B1,"(零除数)")

 

[savid]

（我不会说中文。所以，我希望谷歌翻译得好。）
您始终可以使用 IFERROR() 函数来抑制错误消息。
例子：

=IFERROR(A1/B1,"")
=IFERROR(A1/B1,"(零除数)")

Oh, Greg, although this is not the result I wanted, but thank you very much for replying to me. Your Chinese translation is very good. (I remember that I posted it in English, but I don’t know why it became a Chinese post.)

 

[savid]

（通过谷歌翻译回答这个）。 欢迎来到董事会！ 尝试用以下内容替换您当前的公式，如果单元格 B7 中有数字，它只会返回计算（否则它不会返回任何内容）：

=IF(B7<>0,C7/B7,"")

Thank you, your answer is very good, but not what I want, thank you for replying to me.

 

[Joe4]

Thank you, your answer is very good, but not what I want, thank you for replying to me.

Then obviously it is not clear to us what you are after then.
Please explain how it is not what you want, and what you are looking for.

 

[savid]

Then obviously it is not clear to us what you are after then.
Please explain how it is not what you want, and what you are looking for.

This may be a systematic judgment. When I fill in the next line, it will automatically get the formula of the previous line. Or after filling in the formula, use some mysterious shortcut keys to delete the content in the table without deleting the formula (just like deleting the content without deleting the format). When you click on the table, blank content is displayed instead of a string of formulas.When the formula recognizes the content, it automatically calculates the answer. I agree with the latter possibility, but this is just my guess, because I don't know how it came about. I hope my explanation can help you understand my question better. It's a pity that the file has been saved by me, so it won't appear again. Maybe this is really just a bug.

 

[Joe4]

I am still not certain I understand what you are trying to get at.

If you set up a table, and insert new rows, I believe it will automatically carry the formulas down to the new row.
So if you have an issue with one of your formulas, you will probably need to recreate the table again, using one of the formulas that Greg or I gave you.

 

[savid]

I am still not certain I understand what you are trying to get at.

If you set up a table, and insert new rows, I believe it will automatically carry the formulas down to the new row.
So if you have an issue with one of your formulas, you will probably need to recreate the table again, using one of the formulas that Greg or I gave you.

Okay, you are really enthusiastic, thank you very much. I am just curious about its principle. If I encounter this situation again in the future, I will share the file with you in time, thank you again.

 

[Joe4]

You are welcome.