Re: [O] Check on empty does not work

2014-06-01 Thread Cecil Westerhof
2014-06-01 12:58 GMT+02:00 Michael Brand : > On Sun, Jun 1, 2014 at 12:00 PM, Cecil Westerhof > wrote: > > 2014-06-01 11:50 GMT+02:00 Cecil Westerhof : > >> I am trying the following: > >> #+TBLFM: @-I$4..@+I$4 = if("$3" == "nan", string(""), $3 - $2) ; > %.1f > >> and: > >> #+TBLFM: @-I$

Re: [O] Check on empty does not work

2014-06-01 Thread Michael Brand
Hi Cecil On Sun, Jun 1, 2014 at 12:00 PM, Cecil Westerhof wrote: > 2014-06-01 11:50 GMT+02:00 Cecil Westerhof : >> 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) ; %

Re: [O] Check on empty does not work

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

[O] Check on empty does not work

2014-06-01 Thread Cecil Westerhof
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