2014-06-01 11:50 GMT+02:00 Cecil Westerhof <cldwesterhof@gmail.com>:

> I am trying the following:
>     #+TBLFM: @-I$4..@+I$4 = if("$3" == "nan", string(""), $3 - $2) ; %.1f
> and:
>     #+TBLFM: @-I$4..@+I$4 = if("$3" == "", string(""), $3 - $2) ; %.1f
>
> But in both case the fourth field is filled when the third field is empty.
> What am I doing wrong?
>
> I am using version 8.2.1.
>

​The following does work:
    #+TBLFM: @-I$4..@+I$4 = if($3 - $2 == -$2, string(""), $3 - $2) ;

But is not what is described.

I removed
    %.1f
because that displays an empty string as 0.0.

Is it possible to use %.1f without making an empty field displayed as 0.0?

-- 
Cecil Westerhof