title: MS Excel: Return value "$" sign if there's any value between two dates, if not, a "@" sign
body: <p>I'm searching for the formula that would return a &quot;$&quot; sign as a result IF there's any values/datas  between January 1 to January 31 2020 in the tabs TEST 1 AND/OR in tab TEST 2? And if there's no values in any of those tabs, it would result as a &quot;@&quot; sign.</p>
  <p>tab name &quot;TEST 1&quot;</p>
  <pre><code>      A               B              C               D  
    ## DATE ##    ## AMOUNT ##    ##CATEGORY ##     
  1. Jan-1-2020        10$          Internet        FORMULA??
  2. Jan-2-2020        50$          Phone bill
  3. Jan-5-2020         0$          Grocery
  4.                                               Jan-1-2020
  5.                                               Jan-31-2020
          
  </code></pre>
  <p>tab name &quot;TEST 2&quot;</p>
  <pre><code>      A               B              C                
    ## DATE ##    ## AMOUNT ##    ##CATEGORY ##     
  1. Jan-1-2020      40 $          Rent            
  2. Jan-2-2020       75$          Entertainment
  3. Jan-5-2020      100$          Car repairs
  </code></pre>
  <p>P.S. The formula would only be entered in cell D1 of tab &quot;TEST 1&quot;</p>
  <p>Thanks in advance for your help/suggestions!</p>