Uwe Brauer <o...@mat.ucm.es> writes: > Hello > > Consider the following table. > > > | Name | Ex 1 | Ex2 | Ex + Ex2 | > | smith | 1 | 2 | 3 | > | miller | | | 0 | > #+TBLFM: $4=$2+$3 > > > Miller has no entries in Ex1 and Ex2 but when using C-u C-u C-c C-c also > Ex2+Ex3 gets an entry namely zero. I don't like this I would prefer if > this field remains empty. > > Any way of achieving this?
I think something like NaN was introduced to Org-tbls, but I don't remember the exact syntax, maybe try with 'nan': http://lists.gnu.org/archive/html/emacs-orgmode/2012-12/msg00983.html -- cheers, Thorsten
