Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Hi Pritantha,
RANGESUM(PRE_2016,LIFE_PRE-GV-LS,POL_FEES,CESS1)*IF(EFF_DATE <= '01/05/2016',0.11,0.15)
Regards!
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)
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)
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?
Thkx........
Thkx......