>>> "BB" == Bruno Barbier <brubar...@gmail.com> writes:
> Hi,
> Uwe Brauer <o...@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/
smime.p7s
Description: S/MIME cryptographic signature
