What is wrong with this IIF statment?

[Gina Maylone]

Points1: IIf([points] Between 3 And 5,2,0),IIf([points] Between 6 And 9,4,0)



I've used nested IIF before, but not with "between".

TIA!

[orange]

What does the ,2,0 mean??? What are you trying to do --in plain English?

Syntax details and example of IIF

[isladogs]

Try this amended version

Points1: IIf([points] Between 3 And 5,2,IIf([points] Between 6 And 9,4,0))

[June7]

The IIf expressions are not nested. What error message?

Try:

Points1: IIf([points] Between 3 And 5, 2, IIf([points] Between 6 And 9, 4, 0))

[Gina Maylone]

Orange, If the members points are between 3 and 5, then assign them 2, or 0, if they are between 6 and 9 then assign them 4 or zero. I should probably only have one zero at the end now that I think of it. I ended up doing in the long way, but I don't like it. I'll try your suggestion Ridders. And June, they are nested, they work fine separately.

Thanks all, you rock!

[June7]

The original posted expression is not nested. It is two separate IIf and should error.

[Gina Maylone]

This worked, thanks Ridders! Points1: IIf([points] Between 3 And 5,2,IIf([points] Between 6 And 9,4,0))