Hi I'm trying to understand a formula and write it in c# but so far I haven't managed to understand what this formula does, could someone please explain?
嗨,我正在尝试理解一个公式并将其写入c#但到目前为止我还没有理解这个公式的作用,有人可以解释一下吗?
if(if(c57=> d57;g57;h57)<>0;(((if(c57>=d57;d57;c57))*100/11))/(if(c57 >=d57;c57;d57)));(100/11)))
what really gets me lost is the <>0, I've googled some time but so far haven't found what it does. Please could someone explain?
真正让我迷失的是<> 0,我用谷歌搜索了一段时间,但到目前为止还没有找到它的作用。请有人解释一下吗?
5 个解决方案
#1
5
<>0 is the equivalent of "not equal to Zero"
<> 0相当于“不等于零”
In this case it may be equivalent to "not False", for example taking part of the formula:
在这种情况下,它可能等同于“非假”,例如参与公式的一部分:
if(c57=> d57)<>0
Evaluate whether C57 is NOT >= D57
评估C57是否> = D57
#2
5
<> means "not equal", as in ≠. Also known as != in most programming languages.
<>表示“不相等”,如≠。在大多数编程语言中也称为!=。
#3
2
It depends on the language, but in a majority of them <> means 'does not equal'.
这取决于语言,但在大多数语言中,<>表示“不等于”。
#4
2
<> is the not equal to operator.
<>是不等于运算符。
a1<>0 is the same as a1!=0 in C#.
a1 <> 0与C#中的a1!= 0相同。
See http://office.microsoft.com/en-us/excel-help/calculation-operators-and-precedence-HP010342223.aspx?CTT=1 for the documentation on Excel's calculation operators
有关Excel计算运算符的文档,请参见http://office.microsoft.com/en-us/excel-help/calculation-operators-and-precedence-HP010342223.aspx?CTT=1
#5
2
<> is the inequality operator, meaning that a <> b is a is not equal to b. Which would be written as a != b in C#.
<>是不等式运算符,意味着<> b是a不等于b。哪个在C#中写成!= b。
As far as I know, the only languages that use <> are VB/VbScript (which is what Excel syntax is based on), SQL, BASIC and Pascal. In T-SQL you can actually use !=, but it's non-standard SQL so <> is preferred.
据我所知,使用<>的唯一语言是VB / VbScript(这是Excel语法所基于的),SQL,BASIC和Pascal。在T-SQL中,您实际上可以使用!=,但它是非标准SQL,因此<>是首选。
#1
5
<>0 is the equivalent of "not equal to Zero"
<> 0相当于“不等于零”
In this case it may be equivalent to "not False", for example taking part of the formula:
在这种情况下,它可能等同于“非假”,例如参与公式的一部分:
if(c57=> d57)<>0
Evaluate whether C57 is NOT >= D57
评估C57是否> = D57
#2
5
<> means "not equal", as in ≠. Also known as != in most programming languages.
<>表示“不相等”,如≠。在大多数编程语言中也称为!=。
#3
2
It depends on the language, but in a majority of them <> means 'does not equal'.
这取决于语言,但在大多数语言中,<>表示“不等于”。
#4
2
<> is the not equal to operator.
<>是不等于运算符。
a1<>0 is the same as a1!=0 in C#.
a1 <> 0与C#中的a1!= 0相同。
See http://office.microsoft.com/en-us/excel-help/calculation-operators-and-precedence-HP010342223.aspx?CTT=1 for the documentation on Excel's calculation operators
有关Excel计算运算符的文档,请参见http://office.microsoft.com/en-us/excel-help/calculation-operators-and-precedence-HP010342223.aspx?CTT=1
#5
2
<> is the inequality operator, meaning that a <> b is a is not equal to b. Which would be written as a != b in C#.
<>是不等式运算符,意味着<> b是a不等于b。哪个在C#中写成!= b。
As far as I know, the only languages that use <> are VB/VbScript (which is what Excel syntax is based on), SQL, BASIC and Pascal. In T-SQL you can actually use !=, but it's non-standard SQL so <> is preferred.
据我所知,使用<>的唯一语言是VB / VbScript(这是Excel语法所基于的),SQL,BASIC和Pascal。在T-SQL中,您实际上可以使用!=,但它是非标准SQL,因此<>是首选。