title: Multiple IF AND/OR Statement Returning Met/Not Met Text
body: <p>I have been working on a formula for a couple of weeks now, I've looked online and on numerous occasions thought I had found the answer, but alas I still don't have a working formula. </p>
  
  <p>I understand the rule that we should not ask duplicate questions, but from looking through StackOverflow I haven't found anything that has solved my issue. I thought this post was it - <a href="https://stackoverflow.com/questions/15753961/multiple-if-and-statements-excel#_=_">https://stackoverflow.com/questions/15753961/multiple-if-and-statements-excel#<em>=</em></a> - but once again I could not get it to work.</p>
  
  <p>So to my problem - I have two columns of information in table format:</p>
  
  <p>Column 1 - SLA Priorities of Tickets from a ticketing system.</p>
  
  <p>Example: P1, P2, P3, P4 Etc.. (P1 ~ Very High, P2 ~ High Etc.)</p>
  
  <p>Column 2 - The initial response time to a specific ticket.</p>
  
  <p>Example: 01:00, 00:44, 12:00 (01:00 ~ One Hour, 00:44 ~ Fourty Four Mins, Etc.)</p>
  
  <p>I then want to add a column which will have a final value of "Met" or "Not Met". This will let me know if the ticket response was within SLA (Service Level Agreement).</p>
  
  <p>PSEUDO CODE: </p>
  
  <pre><code>IF SLACELL EQUALS P1 AND IRTCELL &lt;=1HOUR PRINT "MET", IF NOT PRINT "NOT MET", OR IF SLACELL EQUALS P2 AND IRTCELL &lt;=2HOURS PRINT "MET", IF NOT PRINT "NOT MET", OR IF SLACELL EQUALS P3 AND IRTCELL &lt;=4HOURS PRINT "MET", IF NOT PRINT "NOT MET", OR IF SLACELL EQUALS P4 AND IRTCELL EQUALS &lt;=12 PRINT "MET", IF NOT PRINT "NOT MET"
  </code></pre>
  
  <p>One of my many Attempts:</p>
  
  <pre><code>=IF([@[SLA Priority]]="P1",IF([@[Initial Response Time]]&lt;=1,"Met", "Not Met")),IF(AND([@[SLA Priority]]="P2",IF([@[Initial Response Time]]&lt;=2,"Met", "Not Met")),IF(AND([@[SLA Priority]]="P3",IF([@[Initial Response Time]]&lt;=4,"Met", "Not Met")),IF(AND([@[SLA Priority]]="P2",IF([@[Initial Response Time]]&lt;=2,"Met", "Not Met")))
  </code></pre>
  
  <p>Can someone help me with this? I'm really struggling!</p>
  
  <p>Thanks in advance!
  Max</p>