我的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éonisted'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.

当然，Internet上有几个可以检查的资源，但是我喜欢使用这一资源:

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

1. 使用单词 Excel Function 的Google英文功能.始终使用以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更改为要查看的语言的缩写，然后导航到该新URL.我不全部知道，但是其中一些是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.

在您的情况下，您想用法语，因此用fr-fr替换en-us，您将看到法语的函数名称. 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屋！