Re: org-table, empty cells and nan

2023-06-16 Thread Uwe Brauer
>>> "BB" == Bruno Barbier writes: > Hi, > Uwe Brauer 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 | >>

Re: org-table, empty cells and nan

2023-06-16 Thread Bruno Barbier
Hi, Uwe Brauer 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 |

org-table, empty cells and nan

2023-06-16 Thread 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