Nested IFF

[JaneMore]

Could someone show me a example of a nested IIF statement

=IIf([CountryRegion]="US", "No", "Yes")

I wanted to also list Canada as No would I use a nested statement ? Here if so could someone give me an example ?

 

[james_lankford]

=iif
(
  [countryRegion] = "US", 
  "United States", 
  iif
  (
    [countryRegion] = "Canada", 
    "Not United States", 
    "somethign else"
  )
)

 

[mathematician]

Could someone show me a example of a nested IIF statement

=IIf([CountryRegion]="US", "No", "Yes")

I wanted to also list Canada as No would I use a nested statement ? Here if so could someone give me an example ?

=IIf([CountryRegion]="US", "No", [CountryRegion]="Canada","No")

 

[mathematician]

Could someone show me a example of a nested IIF statement

=IIf([CountryRegion]="US", "No", "Yes")

I wanted to also list Canada as No would I use a nested statement ? Here if so could someone give me an example ?

Sorry for post #3 its wrong. The easiest nested If in access is the use of SWITCH function. That's what I wanted to use. So it should be
=SWICTH([CountryRegion]="US", "No", [CountryRegion]="Canada","No")

 

[JaneMore]

Thank you both for your help and examples , Also thank you for teaching me about the SWITCH function Mathematician