title: Nested IF statements in Excel [Over the 7 allowed limit]
body: <p>I am trying to create a spreadsheet which automagically gives a grade to a student based on their marks they got.</p>
  <p>I've apparently hit Excel's nested IF statement limit which is 7.</p>
  <p>Here's my if statement:</p>
  <pre><code>=IF(O5&gt;0.895,&quot;A+&quot;,IF(O5&gt;0.845,&quot;A&quot;,IF(O5&gt;0.795,&quot;A-&quot;,IF(O5&gt;0.745,&quot;B+&quot;,IF(O5&gt;0.695,&quot;B&quot;,IF(O5&gt;0.645,&quot;B-&quot;,IF(O5&gt;0.595,&quot;C+&quot;,IF(O5&gt;0.545,&quot;C&quot;,&quot;D&quot;))))))))
  </code></pre>
  <p>I was reading online that I could create a VBA script and assign it that, but I dont know anything about VBA....so if someone could help me write a VBA for this, would be awesome.</p>
  <p>Its still missing the C- grade and anything lower should be awarded a D mark.</p>
  <p>This is the grading scheme I am trying to create...:</p>
  <blockquote>
  <p>A+   89.500 - 100.000   Pass with Distinction</p>
  <p>A  84.500 - 89.490  Pass with Distinction</p>
  <p>A-  79.500 - 84.490  Pass with Distinction</p>
  <p>B+  74.500 - 79.490  Pass with Merit</p>
  <p>B  69.500 - 74.490  Pass with Merit</p>
  <p>B-  64.500 - 69.490  Pass with Merit</p>
  <p>C+  59.500 - 64.490  Pass</p>
  <p>C  54.500 - 59.490  Pass</p>
  <p>C-  49.500 - 54.490  Pass</p>
  <p>D  0.000 - 49.490  Specified Fail</p>
  </blockquote>
  <p>I wouldn't mind going down the VBA route, however my understanding of VB language is absolutely minimal (don't like it)...if this gets too tedious, I was thinking to create a small php/mysql application instead.</p>