Expression help

[#1]

Dear Experts,

My expression like this,

IF(EFF_YEAR=2015,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.11,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.15)

I want to change this to have the results like ,

IF(EFF_DATE BEFORE 01/05/2016,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.11,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.15)

wHATS WRONG WITH THIS . CAN ANY ONE HELP?

pRIYANTHA.

[Anonymous]

Hi Pritantha,

RANGESUM(PRE_2016,LIFE_PRE-GV-LS,POL_FEES,CESS1)*IF(EFF_DATE <= '01/05/2016',0.11,0.15)

Regards!

[MayilVahanan · Accepted solution]

Hi

Try like this

IF(EFF_DATE <= 01/05/2016,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.11,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.15)

[muthukumar77]

Hi,

=IF(EFF_DATE < '01/05/2016',RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.11,RANGESUM(PRE_2016+LIFE_PRE-GV-LS+POL_FEES+CESS1)*.15)

[sunny_talwar]

I think we would all be guessing for the right answer without a sample to play around with (plus knowing the expected output). Would you be able to provide one?

[#6]

Thkx........

[#7]

Thkx......