Need help in formula

[Mohini79]

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

[binuacs · Accepted solution]

@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 solution]

@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?