title: Multiple Cells Nested IF Formula Excel
body: <p>I am trying to write a formula in Excel from two different cells. Here is what I have:</p>
  
  <pre><code>IF C5="US" AND I5="C" THEN="1,000"
  IF C5="US" AND I5="V" THEN="2,500"
  IF C5="US" AND I5="F" THEN="2,500"
  IF C5="NIFA" AND I5="C" THEN="1,000"
  IF C5="NIFA" AND I5="V" THEN="2,500"
  IF C5="NIFA" AND I5="F" THEN="2,500"
  IF C5="West" AND I5="C" THEN="1,000"
  IF C5="West" AND I5="V" THEN="2,000"
  IF C5="West" AND I5="F" THEN="2,000"
  </code></pre>
  
  <p>Here is what I currently have:</p>
  
  <pre><code>=IF(C5="US",IF(I5="C","1,000",IF(I5="V","2,500",IF(I5="F","2,500",IF(C5="NIFA",IF(I5="C","1,000",IF(I5="V","2,500",IF(I5="F","2,500",IF(C5="West",IF(I5="C","1,000",IF(I5="V","2,000",IF(I5="F","2,000"))))))))))))
  </code></pre>
  
  <p>The issue I am having with this formula is that anything is not US in C5 returns as "FALSE" - all of the US are fine. </p>
  
  <p>Thanks in advance!</p>