[O] Distinguish between blank and zero in org-mode spreadsheet

[Bob Newell]

Can't find out about this anywhere.  My apologies if I missed something simple or something already posted.

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.

I made it work with the following elisp example:

$9 = '(if (eq $2 "") "" (* (string-to-number @2$8) (string-to-number $1)));S

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.

The problem obviously revolves around a blank cell being interpreted as zero. That's all well and good, and quite correct, but makes distinguishing blank and explicit zero more difficult.