Discussions

Expand all | Collapse all

If Statment Clarification

  • 1.  If Statment Clarification

    Posted 09-28-2018 16:35
    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.






  • 2.  RE: If Statment Clarification

    Posted 09-28-2018 16:43
    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.







  • 3.  RE: If Statment Clarification

    Posted 09-28-2018 16:53
    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


  • 4.  RE: If Statment Clarification

    Posted 09-28-2018 16:58


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





  • 5.  RE: If Statment Clarification

    Posted 09-28-2018 17:07
    I think so....What does the <> mean when you replace the =


  • 6.  RE: If Statment Clarification

    Posted 09-28-2018 17:08
    Not Equal To


  • 7.  RE: If Statment Clarification

    Posted 09-28-2018 17:20
    I will give this a go - thanks so much for your help