you have to be more specific to get specific assistance
your example is unclear with the 'but' condition.
In general consider
1. if there are NULLs invloved. This will impact the process greatly. a formula will stop evaluating when it hits a NULL unless you explicitly state how to handle it. This can either be in the formula or in the formula editor "NULL options' pick list.
2. Consider a hierarchy of condition sets. Once a condition set is met the formula stops evaluating. If you have multiple 'if-then' statements your second 'if-then' only runs against the rows that did not meet the first 'if-then'
3. How and where you use parenthesis in each condition set
4. consider using "NOT()" in conditions
for example
if {Table1.Field1} > X OR ({Table1.Field1} < X and {Table2.Field2 }= X)
then "Text String Here" else
if condition set 2 here...
Edited by DBlank - 23 Mar 2015 at 7:33am