From Access to Excel

[Glenn_H]

Good day to all.

After searching this and other forums, I am at a loss for how to transcribe
the following access formula to excel.


IIf([Gender]="Male","1",IIf([Gender]="Female","2",IIf([Gender]="Transgender","3",IIf([Gender]="Unknown/Unreported","9"))))

And assistance will be appreciated.

Glenn H.

 

[Mike]

Maybe single quotes instead of double

 

[Glenn_H]

I should have mentioned that I tried the single quotes.

I will also mention that the "Gender" is found in cell D2.

Is there an Iif function in Excel?

Maybe single quotes instead of double

Good day to all.

After searching this and other forums, I am at a loss for how to transcribe
the following access formula to excel.


IIf([Gender]="Male","1",IIf([Gender]="Female","2",IIf([Gender]="Transgender","3",IIf([Gender]="Unknown/Unreported","9"))))

And assistance will be appreciated.

Glenn H.

 

[dlw]

replace [Gender] with D2 and replace IIF with IF

I should have mentioned that I tried the single quotes.

I will also mention that the "Gender" is found in cell D2.

Is there an Iif function in Excel?

Maybe single quotes instead of double

Good day to all.

After searching this and other forums, I am at a loss for how to transcribe
the following access formula to excel.


IIf([Gender]="Male","1",IIf([Gender]="Female","2",IIf([Gender]="Transgender","3",IIf([Gender]="Unknown/Unreported","9"))))

And assistance will be appreciated.

Glenn H.

 

[Glenn_H]

That did the trick.

Thanks to all.

Glenn H.

replace [Gender] with D2 and replace IIF with IF

I should have mentioned that I tried the single quotes.

I will also mention that the "Gender" is found in cell D2.

Is there an Iif function in Excel?

Maybe single quotes instead of double

:

Good day to all.

After searching this and other forums, I am at a loss for how to transcribe
the following access formula to excel.


IIf([Gender]="Male","1",IIf([Gender]="Female","2",IIf([Gender]="Transgender","3",IIf([Gender]="Unknown/Unreported","9"))))

And assistance will be appreciated.

Glenn H.