title: is there an IF formula to read multi function?
body: <p>I have 3 columns and one of them in remark the 3rd one, my first column is status which is (CLOSED &amp; OPEN) and second column is target date, now my question is how is it possible to read the 1st column and 2nd column in my remarks as "Reminder, Over Due, And DONE" if its CLOSED?</p>
  
  <p>I tried this formula:</p>
  
  <p><code>=IF(AG18&gt;TODAY(),"Over Due",IF(AND(D18="CLOSED","OPEN",D18,"DONE",""),"Reminder","Done"))</code></p>
  
  <p>It works but the 1st column is not shown.</p>