Why is this formula not working?

[The X-Man]

Hi all

Can anyone tell me why this formula is not working or what I am doing wrong? There are plenty of Nurse Practitioners in my data but it doesn't post the 0.85, it just posts 1.

Mid-Level: IIf([PerfProvType]="[Nurse Practitioner]" Or [PerfProvType]="[Physician Assistant]" Or [PerfProvType]="[Midwife]",0.85,1) Thanks n advance

[ranman256]

you are telling the field [PefProvType] to literally = "[Nurse Practitioner]" (with brackets in the name)

brackets without quotes are a field value
inside quotes is the literal assignment

you may want:

IIf([PerfProvType]="Nurse Practitioner" Or [PerfProvType]="Physician Assistant" Or [PerfProvType]="Midwife",0.85,1)

[The X-Man]

Thanks Ranman

That worked perfectly. I thought I had to put brackets around everything that had a space between words.