Need help in formula

Question

Hi,

I need help in below formula

IF [SUM_INSURED]>500000 THEN 0.35 ELSEIF [SUM_INSURED]>200000 THEN 0.45 ELSE "" ENDIF

I want to apply between function as below.

IF [SUM_INSURED] between 500000-100000 THEN 0.35 ELSEIF [SUM_INSURED] between 200000 - 500000 THEN 0.45 ELSE "" ENDIF

Please help thanks in advance

Vishwa.yxmd

binu_acs · Accepted Answer

@Mohini79 you can update your formula like below IF [SUM_INSURED]>=500000 AND [SUM_INSURED] <= 1000000 THEN 0.35 ELSEIF [SUM_INSURED]>=200000 AND [SUM_INSURED]< 500000 THEN 0.45 ELSE "" ENDIF

Yoshiro_Fujimori · Accepted Answer

@Mohini79 , The condition of "[Field] is between m and n" can be expressed as [Field] > m AND [Field] < n e.g. [SUM_INSURED] between 500000-100000 is expressed as [SUM_INSURED] < 500000 and [SUM_INSURED] > 100000 (add "=" as necessary) The rest of the IF_THEN_ELSE sentence remains the same. Do I answer to your question?