Uwe Brauer <o...@mat.ucm.es> writes:
> Hi
>
> Consider please the following table
>
>
>
> | Name | E1 | E2 | E3 | E4 | Res |
> |--------+----+----+----+----+-----|
> | Entry1 | | | | | NP |
> | Entry2 | 10 | 20 | 30 | 40 | 10 |
>
> #+TBLFM: $6=if("$2" == "nan" , string("NP"),($2+$3+$4+$5)/10);E
>
> The last column contains a string NP if the corresponding cell in the
> second column is empty.
>
> However when I consider
>
> | Name | E1 | E2 | E3 | E4 | Res |
> |--------+----+----+----+----+-----|
> | Entry1 | | | | | NP |
> | Entry2 | 10 | 20 | 30 | 40 | 10 |
> | Entry3 | 10 | | 20 | 30 | nan |
>
> #+TBLFM: $6=if("$2" == "nan" , string("NP"),($2+$3+$4+$5)/10);E
>
> The last row behaves strangely the cell in the second column is *not*
> empty but the cell in the third one is, nevertheless the cell in the
> last column contains the string nan, which I don't understand.
>
> Any help would be appreciated
>
> Thanks
>
> Uwe Brauer
The empty column for Entry3 is in column 3 and not column 2. Try
toggling the Col/Row numbers.
Cheers
Loris
--
This signature is currently under construction.
