title: Using IsEmpty function in a filemaker Pro (v9) calculation with multiple fields
body: <p>I want to write a simple calculation to return a value based on a heirarchy of fields.</p>
  
  <p>If the first field is empty, I want it to return the second, and if the second is empty, the third. I have tried the following but it only returns the first value. </p>
  
  <pre><code>If (IsEmpty (Field1 = 1) ; Field2;
  If (IsEmpty (Field2 = 1); Field3; Field1))
  </code></pre>
  
  <p>I was able to get the first or third value to appear by using:</p>
  
  <pre><code>If (IsEmpty (Field1) &amp;
  If (IsEmpty (Field2); Field3; Field1))
  </code></pre>
  
  <p>But of course this doesn't show the <code>Field2</code> at all. </p>
  
  <p>Is there something along the lines of:</p>
  
  <pre><code>If (IsEmpty (Field1) &amp;
  If (IsEmpty (Field2); Field3; Field1, Field2))
  </code></pre>
  
  <p>which I can use? <em>This obviously doesn't work because there are too many parameters in the function.</em> </p>
  
  <p>Any help would be very much appreciated! :-)</p>