>>> "Michael" == Michael Brand <michael.ch.br...@gmail.com> writes:
Hi Michael > if(typeof(vmean($1..$7)) == 12, string(""), vmean($1..$7); E This is precisely what I was looking for, thanks a lot. I meanwhile circumvent the problem by | Name | E1 | E2 | E3 | E4 | Pre | Res | |--------+----+----+----+----+-----+-----| | Entry1 | | | | | 0 | NP | | Entry2 | 10 | 20 | 30 | 40 | 100 | 10 | | Entry3 | 10 | | 20 | 30 | 60 | 6 | #+TBLFM: $6=$2+$3+$4+$5::$7=if("$2" == "nan", string("NP"),$6/10);E But your solution is much more elegant.