Error in Formula

S

Sumit

Hi,
I guess I am making some silly mistake. The following formula works when
there is a Baseline available but gives Error when it is not:
IIf(ProjDateValue([Baseline Finish])="NA","N Avl","Avl")

When I change the same formula to following then it works for true and gives
Error when no baseline is available:
IIf(ProjDateValue([Baseline Finish])<>"NA","Avl","N Avl")

Where am I wrong?
Regards,
Sumit
 
J

JeffT

Sumit,
What did you do, I'm having the same problem.

Sumit said:
Hi I could resolve this problem, as expected i did a silly mistake.

Regards,
Sumit.

Sumit said:
Hi,
I guess I am making some silly mistake. The following formula works when
there is a Baseline available but gives Error when it is not:
IIf(ProjDateValue([Baseline Finish])="NA","N Avl","Avl")

When I change the same formula to following then it works for true and gives
Error when no baseline is available:
IIf(ProjDateValue([Baseline Finish])<>"NA","Avl","N Avl")

Where am I wrong?
Regards,
Sumit
Click to expand...
Click to expand...
 
Top