Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Formulas
675 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
12 - Earth
12 - Earth
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')