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