Logical condition syntax in column formulas

[MartinV]

Anybody knows the syntax for logical condition in formulas (MSP2000)
The field is Number1. Incomplete but working formula is IIf( [Status Date]<[Start]; 0; 1

MY desired formula would be
IIf( [Status Date]<[Start] AND [% Complete]=0; 0; 1
optionally
IIf( AND ([Status Date]<[Start]; [% Complete]=0); 0; 1

none of these works! :-( what is the correct syntax? (nothing found in Help!
Many thanks

 

[Gérard Ducouret]

Hello Martin,

On my PC, your formula works well when I change the separator : comma
instead of semi colon
IIf([Status Date]<[Start] And [% Complete]=0,0,1)

Gérard Ducouret

 

[MartinV]

Yes, it works!
Many thanks.
Martin