Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 15, 2023 12:17 AM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 15, 2023 01:44 AM - edited ‎Sep 15, 2023 01:46 AM
Hi,
I made different names for fields and values
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')
