title: Nested IF statement returning false
body: <p>I have a nested if statement is returning  "False" rather than the expected outcome.</p>
  
  <p><strong>Scenario</strong></p>
  
  <p>Table "High VoltageCables" has data in it that default to numeric but may contain characters: <em>kVa</em></p>
  
  <p>Table "Master" checks "High VoltageCables" data as blank or not blank, and returns "Failed Check 1","Passed Check 1". This works fine.</p>
  
  <p>Table "Meta" then checks the results of "Master" and then tests "High VoltageCables" data for length between 1 and 6, <em>regardless of whether record is numeric or string.</em> </p>
  
  <p><strong>Formula</strong></p>
  
  <pre><code>=IF(MASTER!H2="Passed Check 1",IF(LEN('High VoltageCables'!O2)&gt;=1,IF(LEN('High VoltageCables'!O2&lt;6),"Passed Check 2","Failed Check 2")))
  </code></pre>
  
  <p>This is partially succesful, as it returns "Passed Check 2" for the following sample data in the source table "High VoltageCables".</p>
  
  <p>1             <em>numeric,</em> or</p>
  
  <p>1kVa          <em>str,</em> or</p>
  
  <p>50000         <em>numeric</em> </p>
  
  <p>However if a field in "High VoltageCables"is blank, the formula returns "FALSE" rather than "Failed Check 1"</p>
  
  <p>I inherited this task, (and would have preferred to do the whole thing in Access using relatively simple queries) - and unfortunately I am new to nested If statements, so I am probably missing something basic...</p>
  
  <p>NB the data in High VoltageCables <em>must</em> default to numeric for a further check to work.</p>