Forum Discussion

olivermah's avatar
olivermah
Qrew Assistant Captain
6 years ago

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 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.




Formulas and functions

6 Replies

Sort By
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    6 years ago
    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's avatar
    olivermah
    Qrew Assistant Captain
    6 years ago
    Sorry not a value but a field that I specify - wrong choice of words:  I need something like this:

    If Field y = Y and Field X = X, show Field Z
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    6 years ago


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



  • olivermah's avatar
    olivermah
    Qrew Assistant Captain
    6 years ago
    I think so....What does the <> mean when you replace the =