If Statment Clarification
HI There I have an if statment in my formula that I need to try an make a little more precise. I currently have the following: If( [Port of Loading]="Vancouver", [Voyage Dates - Documentation cut...
Forum Discussion
Would this be what you mean?
if(
[Port of Loading]="Vancouver" and [Place of Receipt]="Calgary", [FIELD Z],
If(
[Port of Loading]="Vancouver" and [Place of Receipt]<>"Calgary", [Voyage Dates - Documentation cut off3],
If(
[Place of Receipt]="Calgary" and [Port of Loading]<>"Vancouver",[Voyage Dates - Calgary Documentation Cut off]
)))
