From Access to Excel

  • Thread starter Thread starter Glenn_H
  • Start date Start date
G

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.
 
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 said:
Maybe single quotes instead of double

Glenn_H said:
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.
Click to expand...
Click to expand...
 
replace [Gender] with D2 and replace IIF with IF

Glenn_H said:
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 said:
Maybe single quotes instead of double

Glenn_H said:
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.
Click to expand...
Click to expand...
Click to expand...
 
That did the trick.

Thanks to all.

Glenn H.

dlw said:
replace [Gender] with D2 and replace IIF with IF

Glenn_H said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top