title: Avoid double, identical arguments in IF
body: <p>This image illustrates a budget, where the values for <code>Yearly</code>, <code>Quartly</code>, <code>Monthly</code> etc. are divided down to their per-month value and then summed up:</p>
  
  <p><a href="https://i.stack.imgur.com/DqbV0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DqbV0.png" alt="enter image description here"></a></p>
  
  <p>If nothing has been typed, then I don't want to see a <code>0</code>. Instead, I just want the field kept empty. As shown in row 4.</p>
  
  <p>Therefore I use an <code>IF</code>, where I first check if the calculation gives zero, <code>A2/12+B2/3+C2&gt;0</code>. If it doesn't, then I show the result of <code>A2/12+B2/3+C2</code>; else, nothing is shown: <code>" "</code>.</p>
  
  <pre><code>=IF(A2/12+B2/3+C2&gt;0 ; A2/12+B2/3+C2 ; " ")
  </code></pre>
  
  <p><strong>My question is if I can avoid having the calculation twice in the formula?</strong> <code>A2/12+B2/3+C2</code> is written twice. In my actual scenario, I have some quite large calculations, and it seems quite tedious and error-prone that when I have to fix something in the calculation, then I have to copy/paste it so it is identical in both places in the formula.</p>
  
  <p>Is there are a smarter way to achieve this? A smarter way to perform a calculation but avoid the zero-case? A way that does not include duplicating the calculation?</p>