In between statement in BEx formula

[former_member203111]

Hi Guys,

How do I write a an in-between statement in the BEx formula.

For example, I want to assign a hard coded value of 100 if the value of my KF falls within -10 to +10

I tried : KF (>= -10) AND (<= +10) then 100

How do I write this in BEx formula, can someone please help with the correct syntax.

Thank you.

[MartinMaruskin]

Try to design formula like following:

( KF > -10 ) AND ( KF < 10 ) * 100 + KF

[MartinMaruskin]

try to implement something like following:

( cond1) * ( result_if_cond1_is_tru ) + ( cond2 ) * ( result_if_cond2_is_tru )

Semantics:

+ means ELSE
* means THEN