2014-06-01 11:50 GMT+02:00 Cecil Westerhof <[email protected]>:
> 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
