Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ying-dui-gong-shi-cuo-wu-de-tan-chuang-wu-qu-ji-qi-jie-jue-ce-lve.html
"Pop-up misunderstandings about formula errors and their solution strategies"
When entering a formula into a table, a warning window will sometimes appear to remind us that there is an error in the entered formula. This is an error warning caused by the incorrect input of the formula. How to deal with this situation? Take the SUM function as an example. When this prompt box appears, first click OK to close the error window, then select the edit bar, select the area you want to sum, and press Enter to confirm. At this time, the error prompt box will disappear, so only when you enter a complete and correct formula, the error prompt box will not appear. When an error prompt box appears, we do not want to continue entering the function, but we find that no matter where we click, we cannot cancel the pop-up window. At this time, click the OK button of the error prompt box, and then click "Cancel" on the left side of the edit bar. button to cancel formula input. If you want to enter a formula in the table but don't want the calculation result, as shown in the video, you only need to add a "single quote" in the English input method state before the formula and press the Enter key to confirm.
Like (810)
Reward
支付宝扫一扫
![支付宝扫一扫](/wpcom/picture/wechat_shoukuan.jpg)
评论列表(196条)
测试