Re: Nested IIF expression doesn't return 3rd condition!
- From: Tom van Stiphout <no.spam.tom7744@xxxxxxx>
- Date: Thu, 03 May 2007 07:15:43 -0700
On 3 May 2007 06:47:27 -0700, Bob <technobob@xxxxxxxxxxxxx> wrote:
To test 3 conditions you only need 2 IIf functions.
-Tom.
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
.
- References:
- Prev by Date: Re: accessing a database
- Next by Date: Re: Is There Any Efficient Way To Email Attachments?
- Previous by thread: Re: Nested IIF expression doesn't return 3rd condition!
- Next by thread: Re: Nested IIF expression doesn't return 3rd condition!
- Index(es):
Relevant Pages
|
