On Saturday, 6 Jan 2018 at 09:37, Uwe Brauer wrote:
> The column of reference is E1 per default, which is the second one. The
Ah, okay, I understand now. Thanks.
I see that you have been given a solution elsewhere using vmean but
you could also consider adding "N" to the expression (i.e. after
>>> "Michael" == Michael Brand writes:
Hi Michael
> if(typeof(vmean($1..$7)) == 12, string(""), vmean($1..$7); E
This is precisely what I was looking for, thanks a lot. I meanwhile
circumvent the problem by
| Name | E1 | E2 | E3 | E4 | Pre | Res |
|+++++-+-
>>> "Eric" == Eric S Fraga writes:
> On Friday, 5 Jan 2018 at 13:44, Uwe Brauer wrote:
>> What I meant is this.
> I understood what you meant and your code is working properly. You
> are checking the second column which is the column labelled E1, not
> the one labelled E2 which
On Friday, 5 Jan 2018 at 13:44, Uwe Brauer wrote:
> What I meant is this.
I understood what you meant and your code is working properly. You
are checking the second column which is the column labelled E1, not
the one labelled E2 which is actually the third column... change your
if statement to c
Hi Uwe
On Fri, Jan 5, 2018 at 1:44 PM, Uwe Brauer wrote:
> But fails if there is a row like this
>
> | Name | E1 | E2 | E3 | E4 | Res |
> |+++++-|
> | Entry1 ||||| NP |
> | Entry2 | 10 | 20 | 30 | 40 | 10 |
> | Entry3 | 10 || 20 | 30 | nan |
>
"Eric" == Eric S Fraga writes:
> On Friday, 5 Jan 2018 at 09:28, Uwe Brauer wrote: [...]
>> 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 na
On Friday, 5 Jan 2018 at 09:28, Uwe Brauer wrote:
[...]
> 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.
But the second column is *not*
Uwe Brauer 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
>
>
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