org-table, empty cells and nan

org-table, empty cells and nan

[Uwe Brauer]

Hi 

I have the following table(s)



| Name  | Exam1 | Exam2 | Exercises | Ex1_Ex2 | Total |
|-------+-------+-------+-----------+---------+-------|
| Smith |       |  7.90 |           |    5.81 | NP    |
#+TBLFM: $6=if("$2" == "nan", string("NP"), 0.65*$2+0.25*$3+$4); E f-1

However when colum 2 is not empty but colum 4 is then I obatin *nan*

| Name  | Exam1 | Exam2 | Exercises | Ex1_Ex2 | Total |
|-------+-------+-------+-----------+---------+-------|
| Smith |   5.9 |  7.90 |           |    5.81 |   nan |
#+TBLFM: $6=if("$2" == "nan", string("NP"), 0.65*$2+0.25*$3+$4); E f-1


A solution is to put 0 in colum 4, but for some reasons which are a
complicated to explain, I want to avoid that.

| Name  | Exam1 | Exam2 | Exercises | Ex1_Ex2 | Total |
|-------+-------+-------+-----------+---------+-------|
| Smith |   5.9 |  7.90 |         0 |    5.81 |   5.8 |
#+TBLFM: $6=if("$2" == "nan", string("NP"), 0.65*$2+0.25*$3+$4); E f-1



Any idea how to deal with the situation?

Regards

Uwe Brauer 

Re: org-table, empty cells and nan

[Bruno Barbier]

Hi,

Uwe Brauer <oub@mat.ucm.es> writes:

> A solution is to put 0 in colum 4, but for some reasons which are a
> complicated to explain, I want to avoid that.
>
> | Name  | Exam1 | Exam2 | Exercises | Ex1_Ex2 | Total |
> |-------+-------+-------+-----------+---------+-------|
> | Smith |   5.9 |  7.90 |         0 |    5.81 |   5.8 |
> #+TBLFM: $6=if("$2" == "nan", string("NP"), 0.65*$2+0.25*$3+$4); E f-1
>
>
>
> Any idea how to deal with the situation?

Maybe this formula?

    #+TBLFM: $6=if("$2" == "nan", string("NP"), 0.65*$2+0.25*$3+ if("$4" == "nan", 0, $4)); E f-1

Regards,

Bruno

Re: org-table, empty cells and nan

[Uwe Brauer]

[-- Attachment #1: Type: text/plain, Size: 1093 bytes --]

>>> "BB" == Bruno Barbier <brubar.cs@gmail.com> writes:

> Hi,

> Uwe Brauer <oub@mat.ucm.es> writes:

>> A solution is to put 0 in colum 4, but for some reasons which are a
>> complicated to explain, I want to avoid that.
>> 
>> | Name  | Exam1 | Exam2 | Exercises | Ex1_Ex2 | Total |
>> |-------+-------+-------+-----------+---------+-------|
>> | Smith |   5.9 |  7.90 |         0 |    5.81 |   5.8 |
>> #+TBLFM: $6=if("$2" == "nan", string("NP"), 0.65*$2+0.25*$3+$4); E f-1
>> 
>> 
>> 
>> Any idea how to deal with the situation?

> Maybe this formula?

>     #+TBLFM: $6=if("$2" == "nan", string("NP"), 0.65*$2+0.25*$3+ if("$4" == "nan", 0, $4)); E f-1

Ha nested if, ah, of course

Thanks very very much


-- 
Warning: Content may be disturbing to some audiences
I strongly condemn Putin's war of aggression against the Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the NATO membership of the Ukraine.
I support the EU membership of the Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]