Skip to main content

Hello everyone. 

 

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

I have two fields (A and 😎 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?

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

 

 

Reply


Terms & Conditions