Re: org-table, empty cells and nan

[Uwe Brauer <oub@mat.ucm.es>]

[-- 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 --]