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.
|