title: Excel formula- If value is greater than.. move to next cell
body: <p>I'm pretty new to formula's- what I would like is a formula that <strong>IF</strong> the value in E24 is greater than 150 then the F24 would equal 150 and the offset in G24 would be the remainder.</p>
  
  <p>So for example if E24 was 200, F24 would be 150 and G24 would be 50.</p>
  
  <p>I've played around and this is what I have so far.</p>
  
  <pre><code>=IF(E24 &gt; 150,G24=E24-150,E24)
  </code></pre>
  
  <p>Any help would be appreciated.</p>