title: IF function - is there a way to avoid repeating formula
body: <p>Can't believe I don't know this, but is there a way to avoid repeating a formula in an if statement if the logical test is dependent on it?</p>
  
  <p>i.e.</p>
  
  <p>=IF((SUMIFS formula)=0,"",<em>SUMIFs formula</em>)</p>
  
  <p>I want to replace that SUMIFS function in the false scenario with something short that will tell it to just programmatically repeat the formula it originally tested for. Repeating the formula twice has to have detrimental effects on processing speed. Negligible, maybe, but want to go for best-practices here. Thanks.</p>