If Statment Clarification

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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.




Photo of oliver mah

oliver mah

  • 850 Points 500 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
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.





Photo of oliver mah

oliver mah

  • 850 Points 500 badge 2x thumb
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
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb


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



Photo of oliver mah

oliver mah

  • 850 Points 500 badge 2x thumb
I think so....What does the <> mean when you replace the =
Photo of Chris

Chris, Champion

  • 4,380 Points 4k badge 2x thumb
Not Equal To
Photo of oliver mah

oliver mah

  • 850 Points 500 badge 2x thumb
I will give this a go - thanks so much for your help