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
Solved! Go to 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
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?