Excel不接受任何公式 [英] Excel does not accept any formula
问题描述
我需要在Excel中编写一个公式来查找特定的单词,并根据它们将字符串写到字段中.但是,在第一次尝试之后,我意识到输入的每个公式都显示为false.所以我什至尝试了最简单的方法:
I need to write a formula in Excel to look up specific words and write a string into a field depending on them. However, after first tries I realized that every formula I entered is displayed as false. So I even tried the most simple ones as:
=SUM(H20, B11)
但是仍然会导致语法错误.我的Excel出问题了吗?这是始终显示的错误的屏幕截图:
But still, it causes syntax errors. Is something wrong with my Excel? Here is a screenshot of the error that always shows up:
推荐答案
Excel中的设置很重要,因为它们会影响功能.
Settings in Excel are important, because they affect functions.
无论如何,最简单的方法来了解在公式中使用函数时需要哪种分隔符,这是在使用函数时查看Excel显示的浮动帮助小窗口.
Anyways, the easiest way to know what kind of separator you need when using functions in formula, is looking at the little floating help window Excel shows when using a function.
这在任何Excel版本中均可使用.当您键入函数的完整名称时,Excel将显示一个帮助窗口,说明如何使用公式:
This works in any Excel version. When you type the complete name of a function, Excel shows a little help window explaining how to use the formula:
如您在图像中看到的,分号显示为分隔符.取决于Excel的设置方式,这可能是一个不同的字符,但是无论如何您都可以在此浮动帮助中看到它:)
As you can see in the image, the semicolon is shown as separator. Depending of how Excel has been set up, this could be a different char, but you could see it in this floating help in any case :)
这篇关于Excel不接受任何公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!