Bob Newell <bobnew...@bobnewell.net> writes: > 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.
I don't think thats "well and good, and quite correct", otherwise all the statistics packages wouldn't have the notion of 'Na' (not available) or 'NaN' (Not a Number). I was bothered by the same problem like you, and its makes life quite complicated when trying to write formulas. AFAIL calc actually has the notion of NaN, but it doesn't work in Org tables, at least when I tried (quite some time ago). This would be a great improvement, if table formulas actually could reference 'empty cells'. -- cheers, Thorsten
