title: IF function in Crystal Report
body: <p>Is it possible to have substring/left and if function in crystal report?
  I mean like I want to get the first 2 characters of my name_column 
  then if the substring of the name_column is 'XO' then I would like the new field in formula to be 1000 or if it is 'XD' then it is 2000..
  Any help would be appreciated.. Thank you so much before</p>
  
  <p>NB: I use vb.net and sqlserver</p>