title: Extract all Logical test condition used with IF statement (not nested) and print to separate column
body: <p>I have a list of about 100 rows of formulas. Each row contains a cell which has 1/2/3/4/5/6 IF statements. </p>
  
  <p>I need help to extract all of the logical test strings used for each row e.g. cell C2 contains:</p>
  
  <pre><code>=IF(Payload_Decode!AB74=Payload_Decode!Z92,"OK",IF(Payload_Decode!AB74=Payload_Decode!Z86,"OK",IF(Payload_Decode!AB74=Payload_Decode!Z87,"OK","ERROR")))
  </code></pre>
  
  <p>Input variable:</p>
  
  <ul>
  <li>E2 cell : <em>Payload_Decode!AB74</em> </li>
  </ul>
  
  <p>Comparison variables in separate cells: </p>
  
  <ul>
  <li>G2 cell : <em>Payload_Decode!Z92</em> </li>
  <li>H2 cell : <em>Payload_Decode!Z86</em></li>
  <li>I2 cell : <em>Payload_Decode!Z87</em></li>
  </ul>
  
  <p>I need this to happen to all rows. Here is a screenshot explaining: </p>
  
  <p><a href="https://i.stack.imgur.com/yXNCb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yXNCb.png" alt="enter image description here"></a></p>