title: Need to convert a simple number set to text with if, then, else in Crystal
body: <p>Fairly new to Crystal Reports. Need to convert numbers to text in a formula. This is what I've tried, along with several others, but returns an error. Any suggestions helpful!</p>
  
  <pre><code>IF {Ref_Referrals.ReferralStatusID} = 1 then totext "Open" 
  or if 2 = then totext = "Closed-Sale"
  or if 3 = then totext = "Closed-Expired"
  or if 4 = then totext = "Closed-No Interest"
  or if 5 = then totext = "Closed-Extended"
  or if 6 = then totext = "Closed-Sale(Auto)"
  or if 7 = then totext = "Closed-Future Interest"
  or if 8 = then totext = "Closed Not Qualified"
  else totext is null
  </code></pre>