Dynamic Components make use of spreadsheet formulae. But not all spreadsheets seem to accept the same terminology for logical functions.
What I want to do is to say “If x is greater than y and less than z, return 1”. Some advice is to use nested IF statements. Others use the AND operator.
This forum is populated by clever bods who will know the answer to how best to do it in DCs without even thinking about it. I hope to hear from them.