If Statment Clarification

Question

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 off3],
)

I need to add another field to help drill this down a bit more - want to add the below into the above.

[Place of Receipt]="Calgary", [Voyage Dates - Calgary Documention Cut off],

Essentially, if [Port of Loading] and [place of receipt] both equal these specified values, this field should show a value that I specify. Sorry i'm not sure how to explain it well, hope this make sense.

chrischris · Answer

When you say it should have a value you specify if both conditions are true, do you mean a value you enter? You cannot manually enter a value into a formula field.

olivermah · Answer

Sorry not a value but a field that I specify - wrong choice of words:&nbsp; I need something like this:If Field y = Y and Field X = X, show Field Z

chrischris · Answer

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]&lt;&gt;"Calgary", [Voyage Dates - Documentation cut off3],If([Place of Receipt]="Calgary" and [Port of Loading]&lt;&gt;"Vancouver",[Voyage Dates - Calgary Documentation Cut off])))

olivermah · Answer

I think so....What does the &lt;&gt; mean when you replace the =

chrischris · Answer

Not Equal To

Forum Discussion

If Statment Clarification

6 Replies

Related Content

Clarification on the TextList feature

Help on IF Statment

Re: When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Jinja Code to Check for Empty String

Formula to Calculate percentage based on Checkmarks and dates