Hi ,

I have crystal report formula.can you please help to what is logic for it and how it is works ?

PLease note : The code have varchar(10) datatype.

if {Code} in ['042' to '04299'] then "ABC" else
if {Code} in ['V08' to 'V0899'] then "ABC" else

if {Code} in ['140' to '23999'] then "CBS" else
if {Code} in ['V10' to 'V1099'] then "CBS" else
if {Code} in ['V16' to 'V1699'] then "CBS" else
if {Code} in ['V58' to 'V5812'] then "CBS" else
if {Code} in ['740' to '75999'] then "CBS" else

if {Code} in ['760' to '77999'] then "BBC" else
if {Code} in ['7793' to '7793'] then "BBC" else
if {Code} in ['77984' to '77984'] then "BBC" else
if {Code} in ['V20' to 'V3999'] then "BBC" else


if {Code} in ['940' to '94999'] then "NEWS" else

if {Code} = ['430' to '438'] then "NEW NEWS" else

if {Code} = ['3400' to '3449'] then "ARTICLE" else

if {Code} = ['800' to '829'] then "WHITE PAPER" else

if {Code} = ['570' to '573'] then "RESEARCH PAPER" else
if {Code} = ['8640' to '86419'] then "RESEARCH PAPER" else
if {Code} = ['V427' to 'V427'] then "RESEARCH PAPER" else
if {Code} = ['75162' to '75162'] then "RESEARCH PAPER" else
if {Code} = ['V596' to 'V596'] then "RESEARCH PAPER" else
"Not Reportable"

Thanks in advance