Re: [O] problem with empty column

[Loris Bennett]

Uwe Brauer <address@hidden> 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.