Can&#39;t find out about this anywhere.  My apologies if I missed something simple or something already posted.<div><br></div><div>I want a calculation to appear in column 9 if and only if column 2 is non-blank. If there is an explicit 0 in column 2, I want the calculation to appear in column 9. But if column 2 is blank, I also want column 9 to be blank.<div>
<br></div><div>I made it work with the following elisp example:<div><br></div><div>$9 = &#39;(if (eq $2 &quot;&quot;) &quot;&quot; (* (string-to-number @2$8) (string-to-number $1)));S<br></div></div></div><div><br></div><div>
But the question is, can it be made to work with a calc formula, which would be possibly a little more straightforward? All of the other columns have the same requirement, and some of the formulas are quite long, so doing many, many string-to-number functions makes things very cluttered.</div>
<div><br></div><div>The problem obviously revolves around a blank cell being interpreted as zero. That&#39;s all well and good, and quite correct, but makes distinguishing blank and explicit zero more difficult.</div>