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
