title: Crystal Reports formula to add formatting if the string is not null?
body: <p>I have a secondary phone number that is not always filled out but must still appear on a report. I'm trying to make a simple formula that tests if the string is null and if not add formatting to a phone number.</p>
  
  <p>I can add formatting to the phone number by using:</p>
  
  <pre><code>picture ({table1.PhoneNumber},"(xxx)xxx-xxxx")
  </code></pre>
  
  <p>And I know there is an "IsNull" operator but I can't really figure out the syntax to put the two statements together.</p>
  
  <p>I need to do this:</p>
  
  <p>If the phone number is not null then apply formatting, If it is null then make the string = "N/A"</p>