Like [Slaks pointed out](https://stackoverflow.com/a/6727960/1366033), you can use `Contains` on an `enumerable` collection.  But I think readability suffers.  I don't care if some list ***contains*** my variable; I want to know if my variable is ***in*** some list.  


You can wrap contains in an extension method like so:

```vb
Imports System.Runtime.CompilerServices
Module ExtensionMethods

    <Extension()> _
    Public Function [In](Of T)(ByVal item As T, ByVal ParamArray range() As T) As Boolean
        Return range.Cast(Of T).Contains(item)
    End Function

End Module
```

Then call like this:

```vb
If ToStatus.In("1CE","2TL","2PM") Then
```

I just want to know if there's an approach in VB.NET that can find if a specific value exist on a list or something which can use in my If-else condition. What I'm doing now is to use this:

    If ToStatus = "1CE" Or ToStatus = "2TL" Or ToStatus = "2PM" Then
        'Do something
    Else
        'Do something
    End If

This works fine, but how if I have hundreds of string to compare to `ToStatus` in the future? It will be a nightmare! Now, if such functionality exists, how can I add "And" and "Or" in the statement? 

Thanks in advance!


VB.NET If-Else in List

Here's an overview of **`{{#if}}` statements** in Spacebars

### Property

Of course the simplest possible implementation is when the scoped object has a property that evaluates to a boolean

For example if you had:



    var item = {
      text: 'hello',
      checked: false
    };

Then you could evaluate an if block like this:



    class="{{#if checked}}checked{{/if}}"

### Function

We could also evaluate a function here as well.  Rather than add a function to the item, we can add a function to the helper and it will inherit the datacontext of the item being passed to it.  So if we had the following helper:



    Template.item.helpers({
        saysHi: function() {
          return this.text === "hi";
        }
    });

Then we could run the following code:



    <template name="item">
       {{text}}
       {{#if saysHi}} - Hi Back {{/if}}
    </template>

> [**Note**][1]: The helper's implementation can access the current data context as `this`.


### Function with Parameters

You can also pass any number of parameters to helper functions like this:

Template: `{{frob a b c verily=true}}`  
Helper Call: `frob(a, b, c, Spacebars.kw({verily: true}))`

When applied to our if block, we can do the following:



    {{#if equals owner currentUser._id}}
        <button class="delete">&times;</button>
    {{/if}}

Then add `equals` to our template helper like this:



    Template.item.helpers({
        equals: function(v1, v2) {
            return (v1 === v2);
        }
    });

### Universal Helpers

Since this is a generic method that could be useful anywhere, we should add it to every template instead of recreating it.

> [**Note**][2]: To create a helper that can be used in any template, use `Template.registerHelper`.



    Template.registerHelper('equals',
        function(v1, v2) {
            return (v1 === v2);
        }
    );

### [Here's a working Demo in MeteorPad that includes one of each of the types of IF's constructed here][3]

[1]: https://github.com/meteor/meteor/blob/devel/packages/spacebars/README.md#helper-arguments
[2]: http://docs.meteor.com/#/full/template_helpers
[3]: http://meteorpad.com/pad/kntyBuiyBSyDDfAFZ

I am trying to do what I think should be a very simple task, but have been failing to do so in the past hour. I want to select a select option by default if the user property matches the value.

    <select name="myName">
      {{#each addKeys myTable}} 
        <option value="{{key}}" {{#if currentUser.property === key}}selected="selected"{{/if}}>{{value}}</option>
      {{/each}}
    </select>

Now I thought this was straightforward enough to be implemented. But it turns out that Spacebars do not allow conditional operators other than the negation exclamation mark, so equal signs are out of question. I then tried something horrible for the sake of trying:

In template `myTemplate`:

    <select name="myName">
      {{#each addKeys myTable}}
        <option value="{{key}}" {{isSelected currentUser.property key}}>{{value}}</option>
      {{/each}}
    </select>

In `mytemplate.js` :

    Template.myTemplate.helpers({
      isSelected: function(v1, v2) {
        if (v1 === v2)
          return "selected=\"selected\"";
        return '';
      }
    });

Not only is this code terrible, terrible to look at, it does not work:

    Exception in Meteor UI: String contains an invalid character

I don't understand why something that simple seems so impossible to achieve. Am I missing something there?

Check for equality in Spacebars?

You'll want to check against the RGB value of whatever `InfoBackground` is.

Notice the following returns **`rgb(251, 252, 197)`**





    if ($("#myElement").css('background-color') == 'rgb(251, 252, 197)') {
         alert('hello');
    }



    #myElement { background-color: InfoBackground; }



    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>

    <div id="myElement">Hi</div>




---

*However*, this seems like kind of a fickle approach.  Different browsers might behave differently or implement `InfoBackground` differently.  It would be better to assign a class, property, or data-attribute and then use that to dictate the color.

how to get the the value of background-color property 

    if ($(this).css('background-color') == 'InfoBackground') 
    {
         // it doesn't enter here
    }

How to get a style value of an element - jQuery

Use the `Where` Clause to restrict the set of data in LINQ to XML.  

You can get the value of a particular element by drilling down into the element and calling `.Value`

This will load all the name and value for all the each parameter that is part of an Event that has a condition element with a value of True:



    Dim xdoc As XDocument = XDocument.Parse(str)

    Dim parameters = From e In xdoc.Root.Elements("Events").Elements("Event")
                     From p In e.Elements("Fields").Elements("Parameter")
                     Where e.Element("Condition").Value = "True"
                     Select New With {
                             .Name = p.Attribute("Name").Value,
                             .Value = p.Attribute("Value").Value
                         }

Can anyone help on how to process the information within Fields only when the `Condition` is `True` ?

I've tried For each and if then but I would like something more graceful.


    <?xml version="1.0" encoding="UTF-8" ?>
    <root>
    <Events>  
        <Event Id="1">
            <Condition>True</Condition>
            <Fields>
                <Parameter Name="thisOne" Value="1234" />
                <Parameter Name="notthisOne" Value="xyz" />
                <Parameter Name="thisoneagain" Value="5678" />
                <Parameter Name="notthisoneAgain" Value="abc" />
            </Fields>
        </Event>
        <Event Id="2">
            <Condition>False</Condition>
            <Fields>
                <Parameter Name="thisOne" Value="1234" />
                <Parameter Name="notthisOne" Value="xyz" />
                <Parameter Name="thisoneagain" Value="5678" />
                <Parameter Name="notthisoneAgain" Value="abc" />
            </Fields>
        </Event>
    </Events>  
    </root>

Using If, Then, Else on Condition in XML

## Update with Array Function

**First Attempt**:

So at first I had thought you could just add a second condition to the Array Function like this:

    =AVERAGE(IF(AND($C$2:$C$9={"LA","SF","POR","SEA"},$B$2:$B$9={"North"}),$D$2:$D$9))

Where the `AND` would require each item it be true, but this appears **not to have worked**... and array functions are tricky beasts to debug.

**Second Attempt**:

Instead, what you can do is *extend the `IF` function* with a second IF.  So in the event that the first one is true, the value should return another IF that checks a second criteria.  Only if it meets both criteria, return the score, otherwise it will still return nothing , which won't get picked up by the average function.

So the final thing should look like this:

    =AVERAGE(IF($C$2:$C$9={"LA","SF","POR","SEA"},IF($B$2:$B$9={"North"},$D$2:$D$9)))

### Named Array

Since you are unable to create a column to store the data related to which cities live in the west, it would be best if you had some way to easily update this information instead of hardcoding it throughout your functions.  One thing you can do to is define a name to reference later.  

Just go to Formulas Ribbon > Defined Names Section > Name Manager > New

Then create the array of western city values as a named parameter to be used later

![Named Value](http://i.imgur.com/tO1JPlT.png)

Then you can use it in a formula in place of the array like this:

    =AVERAGE(IF(C2:C9=WestCities,IF(B2:B9="North",D2:D9)))

![Named Usage](http://i.imgur.com/guYUII8.png)


## With PivotTable

Here's my suggestion:

First, add a column for East/West, so you're not stuffing data into a formula

![Data](http://i.imgur.com/jp7ywjN.png)

Then add a pivot table and it will do all you calculations for you.

Set it up like this (make sure to aggregate by Average (not sum):

![Pivot Setup](http://i.imgur.com/rtpfVhN.png)

And it will look like this:

![Pivot](http://i.imgur.com/TxvLhWV.png)

If you want to keep your original formatting, you can just run the formulas off of your pivot table like this:

    =GETPIVOTDATA("Score",Sheet4!$A$3,"E/W","West","S/N","North")

![Pivot Formula](http://i.imgur.com/t3SaXsY.png)

## With West Column

Also, if you had the ability to add in a column for west, you could easily check this with AVERAGEIFS with multiple criteria like this:

    =AVERAGEIFS(D2:D9,A2:A9,"West",B2:B9,"North")

![AverageIfs](http://i.imgur.com/xvh4g59.png)



I am trying to find a formula to check conditions in two different columns and then calculate the average of the corresponding values. The following example reflects what I would like to achieve. Let's say I want to find the average of North-western cities. 

I already identified the average of the western cities with an *array function* like this:

    =AVERAGE(IF($C$3:$C$10={"LA","SF","POR","SEA"},$D$3:$D$10))

Then hit <kbd>Ctrl</kbd> + <kbd>Shift</kbd> + <kbd>Enter</kbd>

Because of how my data is organized, this previous formula is the only way I will be able to determine (manually somewhat) whether a city is located on the east or the west coast.
 
Now I'm missing the part that would say "*And also if the previous column says 'north'* "

![enter image description here][1]


  [1]: http://i.stack.imgur.com/l1jRxm.png

Multi column if statement - Excel

If you'd like to test for equality for every object property, one at a time, in order to compare and contrast two objects and see which individual pieces are different, you can use the following function, adapted from this article on how to [compare all properties of two objects in Windows PowerShell][1]


   
    Function Compare-ObjectProperties {
        Param(
            [PSObject]$leftObj,
            [PSObject]$rightObj 
        )
    
        $leftProps = $leftObj.PSObject.Properties.Name
        $rightProps = $rightObj.PSObject.Properties.Name
        $allProps = $leftProps + $rightProps | Sort | Select -Unique
        
        $props = @()
    
        foreach ($propName in $allProps) {
            
            # test if has prop
            $leftHasProp = $propName -in $leftProps
            $rightHasProp = $propName -in $rightProps
    
            # get value from object
            $leftVal = $leftObj.$propName
            $rightVal = $rightObj.$propName
    
            # create custom output - 
            $prop = [pscustomobject] @{   
                Match = $(If ($propName -eq "SamAccountName" ) {"1st"} Else {
                            $(If ($leftHasProp -and !$rightHasProp ) {"Left"} Else {
                                $(If ($rightHasProp -and !$leftHasProp ) {"Right"} Else {
                                    $(If ($leftVal -eq $rightVal ) {"Same"} Else {"Diff"})
                                })
                              })
                         })
                PropName = $propName
                LeftVal = $leftVal
                RightVal = $rightVal
            }
    
            $props += $prop
        }
    
        # sort & format table widths
        $props | Sort-Object Match, PropName | Format-Table -Property `
                   @{ Expression={$_.Match}; Label="Match"; Width=6}, 
                   @{ Expression={$_.PropName}; Label="Property Name"; Width=25}, 
                   @{ Expression={$_.LeftVal }; Label="Left Value";    Width=40}, 
                   @{ Expression={$_.RightVal}; Label="Right Value";   Width=40}
    
    }


And then use like this:



    $adUser1 = Get-ADUser 'Grace.Hopper' -Properties *
    $adUser2 = Get-ADUser 'Katherine.Johnson' -Properties *   
    Compare-ObjectProperties $adUser1 $adUser2

**Couple Interesting Notes**:

* [How to Test if Element Has Property][2]
* [How to Get Property Value by Name][3]
* [How to Create a Custom PS Object][4]
* [How to Create a Nested Conditional / Ternary Operator][5]
* [How to Format Table with fixed Widths][6]
* Attempted to Colorize output with [VT Escape Sequences][7] or [`Write-PSObject`][8], but couldn't get it to work with fixed column widths which took priority

[1]: https://blogs.technet.microsoft.com/janesays/2017/04/25/compare-all-properties-of-two-objects-in-windows-powershell/
[2]: https://stackoverflow.com/a/48982801/1366033
[3]: https://stackoverflow.com/a/14406385/1366033
[4]: https://stackoverflow.com/a/35905423/1366033
[5]: https://stackoverflow.com/a/34311158/1366033
[6]: https://stackoverflow.com/a/52174495/1366033
[7]: https://stackoverflow.com/a/49038815/1366033 "Virtual Terminal"
[8]: https://gallery.technet.microsoft.com/scriptcenter/Format-Table-Colors-in-e0a4beac

Let's say you have two objects that are identical (meaning they have the same properties and the same values respectively). 

How do you test for equality?


**Example**

`$obj1` & `$obj2` are identical

[![enter image description here][1]][1]


Here's what I've tried:

    if($obj1 -eq $obj2)
    {
        echo 'true'
    } else {
        echo 'false'
    }
    # RETURNS "false"
    
    if(Compare-Object -ReferenceObject $obj1 -DifferenceObject $obj2)
    {
        echo 'true'
    } else {
        echo 'false'
    }
    # RETURNS "false"

**Edit**

This is **not** identical

[![enter image description here][2]][2]


  [1]: https://i.stack.imgur.com/8pPpu.png
  [2]: https://i.stack.imgur.com/QFlHc.png