From Access to Excel
 

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.

From Access to Excel
 

Maybe single quotes instead of double

"Glenn_H" wrote:

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.

From Access to Excel
 

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?

"Mike" wrote:

Maybe single quotes instead of double

"Glenn_H" wrote:

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.

From Access to Excel
 

replace [Gender] with D2 and replace IIF with IF

"Glenn_H" wrote:

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?

"Mike" wrote:

Maybe single quotes instead of double

"Glenn_H" wrote:

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.

From Access to Excel
 

That did the trick.

Thanks to all.

Glenn H.

"dlw" wrote:

replace [Gender] with D2 and replace IIF with IF

"Glenn_H" wrote:

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?

"Mike" wrote:

Maybe single quotes instead of double

"Glenn_H" wrote:

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.