Rpsu (326 ppm)<p>Wouldn't it be nice if one could declare variable or constants in a formula in Google Sheet? Define something once and reuse it multiple times within one formula. </p><p>= declare(VAR=(if(A="";B;A))&amp;&amp;right(VAR,len(VAR))</p><p>(And directly in the sheet, not via apps script.)</p><p><a href="https://mas.to/tags/googlesheet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>googlesheet</span></a> <a href="https://mas.to/tags/semiprogrammer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>semiprogrammer</span></a> <a href="https://mas.to/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>programming</span></a></p>