Re: Nested IIF expression doesn't return 3rd condition!

Current EAC Gross Margin, Return Value
less than 15, 3
greater than 20, 1
greater than 15 and less than 20, 2
exactly 20, ?
exactly 15, ?

I would suspect that this would suit your needs:

EAC Rank: iif([Current EAC Gross Margin]>=20, "1", iif([Current EAC
Gross Margin]<15, "3", "2")

Current EAC Gross Margin, Return Value
20 to +inifinity including 20, 1
15 to 20 including 15, 2
evrything else, 3

Cheers,
Jason Lepack
On May 3, 9:47 am, Bob <techno...@xxxxxxxxxxxxx> wrote:
I'm not sure why this doesn't work...

EACRank: IIf([Current EAC Gross Margin]>20,"1",IIf([Current EAC Gross
Margin]<14.99,"3",IIf(([Current EAC Gross Margin]>14.99) And ([Current
EAC Gross Margin]<19.99),"2")))

The first condition returns a 1 as desired.
The second condition returns a 3
The third condition returns a 1 instead of a 2.

Can anyone help?

Thanks in advance,

Bob


.

Relevant Pages