How Excel hides error values

savid

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

Attachments

  • 微信图片_20211203110527.png
    微信图片_20211203110527.png
    16.3 KB · Views: 15
  • 微信图片_20211203110740.png
    微信图片_20211203110740.png
    19.2 KB · Views: 15
  • 微信图片_20211203110925.png
    微信图片_20211203110925.png
    18.9 KB · Views: 15

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,022
I'm not 100% sure, but perhaps this might address the issue you are struggling with? Turning off this option will stop Excel from automatically filling in formulas, if you do not want it to do that. (translation by google)

我不是 100% 确定,但也许这可以解决您正在努力解决的问题?关闭此选项将阻止 Excel 自动填写公式,如果您不希望它这样做。(谷歌翻译)
 

Attachments

  • 2021-12-16_15-45-55.png
    2021-12-16_15-45-55.png
    32.3 KB · Views: 8
  • 2021-12-16_15-46-11.png
    2021-12-16_15-46-11.png
    121.7 KB · Views: 8

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,181,322
Messages
5,929,304
Members
436,660
Latest member
Mouseinalabyrinth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top