Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF Field A has X value and Field B has Y value give me abc

Topic Labels: Formulas
922 1
cancel
Showing results for 
Search instead for 
Did you mean: 
plyske
7 - App Architect
7 - App Architect

Hello everyone. 

 

I am trying to create a formula with the following logic: 

I have two fields (A and B) and these fields can contain different kind of values. 

Let's say that field A contains value A and field B contains value B, then I want the formula field to return a specific price. The same goes for an example where field A contains value C and field B still contains value B (then it's a different price). 

How would a formula like that look like?

1 Reply 1
Alexey_Gusev
13 - Mars
13 - Mars
Hi,
I made different names for fields and values

 

IF(FldB='valB',
  SWITCH(FldA,
  'valC','different price',
  'valA','specific_price',
  'price for fldB=valB but fldA not A and not C'),
'FldB not valB')