CODEWITHSUNDEEP
c#excel
oskar132
oskar132

Reputation: 839

Can't understand what <>0 means

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?

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?

Upvotes: 2

Views: 1055

Answers (5)

Mathew Thompson
Mathew Thompson

Reputation: 56439

<> is the inequality operator, meaning that a <> b is a is not equal to b. Which would be written as a != b in C#.

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.

Upvotes: 2

halex
halex

Reputation: 16403

<> is the not equal to operator.

a1<>0 is the same as a1!=0 in C#.

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

Upvotes: 2

MrDosu
MrDosu

Reputation: 3435

It depends on the language, but in a majority of them <> means 'does not equal'.

Upvotes: 2

John Kugelman
John Kugelman

Reputation: 361909

<> means "not equal", as in ≠. Also known as != in most programming languages.

Upvotes: 5

David Zemens
David Zemens

Reputation: 53653

<>0 is the equivalent of "not equal to Zero"

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

Upvotes: 5

Related Questions