Using Eval in screener

Hi - could some kind soul please help me with this:

I want to use expression A when condition N is met
Expression B otherwise.

Is eval the right way to do this? If so, how do I define it. If not please suggest alternative

Thanks!

Yes, Eval is the right way to do this. The form would be:

Eval(N,A,B)

That’s pseudocode. This example should actually work when pasted into a blank rule:

Eval(MktCap>2000,ROI%TTM>5,ROE%TTM>10)

If the market cap of a company is greater than $2 billion then it will pass if it has an ROI greater than 5%. If it is under $2 billion then it will pass if it has an ROE greater than 10%.

EDIT: Oh, and I should mention that you can nest Eval statements to form decision trees. Those examples become much more complicated, of course.

thanks!