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

397 0
Showing results for 
Search instead for 
Did you mean: 
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
12 - Earth
12 - Earth
I made different names for fields and values


  'valC','different price',
  'price for fldB=valB but fldA not A and not C'),
'FldB not valB')