我的 excel 公式语法有什么问题? [英] What is wrong with my excel formula syntax?

问题描述

我已经制作了几个公式来动态创建 SQL 查询，但为了使其完美，我想添加一个条件:如果单元格不是空白".

I have made several formula to dynamically create a SQL query but to make it perfect, I want to add a condition : "if cell is not blank".

我尝试了很多不同的语法，但即使使用一个非常简单的语法(参见下面的示例)，我还是遇到了错误.

I've tried a lot of different syntaxe but even with a very simple one (see exemple below), I get an error.

我的公式是:

="""" & SUBSTITUE(E2;"'";"''") & """"

效果很好，给了我Accordéoniste d''hier"

It works well and give me "Accordéoniste d''hier"

我试过了

=IF(E2<>"";"""" & SUBSTITUE(E2;"'";"''") & """";"")

Excel 显示 #NOM?在单元格中，但没有给我一个明确的错误.

Excel display #NOM? in the cell but doesn't give me an explicit error.

我尝试了一个非常简单的方法，但得到了相同的结果:#NOM?

I've tried a very simple one, but I get the same result : #NOM?

=IF(1=1;"Delivered";"")

我尝试过 ISBLANK 但结果相同...我认为有问题但我没有看到...

I've tried ISBLANK but same result... I think there is something wrong and I don't see it...

感谢您的帮助！

推荐答案

@rory 是完全正确的.看起来你的 Excel 是法语的，所以你需要使用 SI 而不是 IF.

@rory is totally right. It looks like your Excel is in French, so you need to use SI instead of IF.

Excel 使用本地公式，因此您需要知道 Excel 设置的任何语言的函数名称.

Excel works with local formulas, so you need to know the name of the functions in whatever language Excel has been set up.

Stack Overflow 总是用英文发布答案，有时像我这样的用户需要将函数翻译成他们的母语.有一个技巧可以用我使用过数百次的特定语言获取函数的名称，并且它在 Stack Overflow 上运行得非常好.

Stack Overflow always post answer in english, and sometimes users like me need the translation of a function to their native languages. There's a trick to get the name of a function in a specific language I've used hundreds of times and it works pretty good with Stack Overflow.

让我们看看你的情况.您看到解决方案正在使用函数 IF，并且您需要知道在您的语言中如何调用该函数.

Let's see your case. You see the solution is using the function IF and you need to know how is called that function in your language.

当然网上有很多资源可以查，不过我喜欢用这个:

Of course there are several sources in Internet where you can check, but I like to use this one:

1. Google 的英文函数，使用词 Excel Function.始终使用以 https://support.office.com
开头的链接

1. Google for the function in english, using words Excel Function. Always use the link that starts with https://support.office.com

1. 使用该链接将带您到有关该功能的官方文档(英文)，但请检查 URL、语言部分(图片中显示 en-us)

1. 将 en-us 更改为您要查看的语言的首字母，然后导航到该新网址.我不知道所有这些，但其中一些是法语的 fr-fr，西班牙语的 es-es，西班牙语的 pt-br葡萄牙语(巴西)，pt-pt 为葡萄牙语，de-de 为德语，依此类推.

1. Change en-us for the initials of the language you want to see, and navigate to that new url. I don't know all of them but some of them are fr-fr for french, es-es for spanish, pt-br for portuguese (brazilian), pt-pt for portuguese, de-de for german, and so on.

在您的情况下，您需要法语，因此将 en-us 替换为 fr-fr，您将看到该函数的法语名称.ISBLANK 和其他函数也同样适用.

In your case, you want in in french so replace en-us with fr-fr and you will see the name of the function in french. Same works for ISBLANK and other functions.

你去吧.现在您知道了该函数的法语名称，您可以将其应用到您的需要中.此技巧适用于 Excel 中记录的所有函数.希望它可以帮助其他用户.

There you go. Now you know the name of the function in french, and you can apply it to your needs. This trick works for all functions documented in Excel. Hope it can help other users.

这篇关于我的 excel 公式语法有什么问题?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！