Multiple conditions in Formula
-
I am having trouble writing a formula that would be akin to a conditional IF statement in Excel or a Like statement in SQL.. Can anyone help?
I'd like to do one of the following--
Formula 1: IF([field A] like 'xyz', 250, 0) -
1 Comment
-
Hi: Try this
Formula1: IF(SEARCH("xyz", [FieldA],0)>0,250,0)
Note: you can use SEARCHREGEX()
Formula 2: IF(AND([FieldB]=5, [FieldC]=6),250,0)
Hope this helps
This discussion has been closed.
← All Discussions Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.