Re: table: problem with nan and if

2021-06-23 Thread Uwe Brauer
> Uwe Brauer writes: > Could you write the formulas in lisp instead? You might be able to control > things more easily: Aha, that I will try. Thanks for pointing it out. So it seems that my question is not trivial. smime.p7s Description: S/MIME cryptographic signature

Re: table: problem with nan and if

2021-06-22 Thread Nick Dokos
Uwe Brauer writes: >> Uwe Brauer writes: > > >> I'm not very familiar with calc, but am wondering if the issue is the >> 'nan'. In many languages, a nan is a 'polluting' variable i.e. once you >> have a nan as a form anywhere in your calculation, the result will >> always be a nan. Many language

Re: table: problem with nan and if

2021-06-22 Thread Uwe Brauer
>>> "t" == tbanelwebmin writes: > About the E format setting, you may look at documentation here: > [[info:org#Formula syntax for Calc]] Thanks I tried, but I think the core of the problem is that $7 needs two ifs with two commands #+begin_src elisp Case I $6 empty #+NAME: test | Name | E1

Re: table: problem with nan and if

2021-06-22 Thread Uwe Brauer
>>> "ESF" == Eric S Fraga writes: > Uwe, > what if you change the E in each equation with N? You'll get 0 entries > when the calculations involve all empty cells which might not be what > you want, of course. In that case I obtain a 0, which I don't want smime.p7s Description: S/MIME cryptogr

Re: table: problem with nan and if

2021-06-22 Thread tbanelwebmin
About the E format setting, you may look at documentation here: [[info:org#Formula syntax for Calc]] Le 22/06/2021 à 09:44, Eric S Fraga a écrit : > Uwe, > > what if you change the E in each equation with N? You'll get 0 entries > when the calculations involve all empty cells which might not be

Re: table: problem with nan and if

2021-06-22 Thread Eric S Fraga
Uwe, what if you change the E in each equation with N? You'll get 0 entries when the calculations involve all empty cells which might not be what you want, of course. -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-566-gf0198e : Latest paper written in org: https://arxiv.org/abs/2106.0509

Re: table: problem with nan and if

2021-06-21 Thread Uwe Brauer
> Uwe Brauer writes: > I'm not very familiar with calc, but am wondering if the issue is the > 'nan'. In many languages, a nan is a 'polluting' variable i.e. once you > have a nan as a form anywhere in your calculation, the result will > always be a nan. Many languages actually have a special f

Re: table: problem with nan and if

2021-06-21 Thread Tim Cross
Uwe Brauer writes: > Hi > > I have the following table > > #+begin_src elisp > #+NAME: test > | Name | E1 | E2 | E3 | Result1 | Result2 | Final | > |---+++-+-+-+---| > | User1 ||| | | 8 | nan| > | User2 ||| |

Re: table: problem with nan and if

2021-06-21 Thread Uwe Brauer
>>> "ESF" == Eric S Fraga writes: > Uwe, > it might be easier if you explained what it is you want to do (at a > higher level) instead of trying to get us to help to fix what you have > done? OK fair enough The situation is as follows, there are two exams 1. The result of the first one

Re: table: problem with nan and if

2021-06-21 Thread Eric S Fraga
Uwe, it might be easier if you explained what it is you want to do (at a higher level) instead of trying to get us to help to fix what you have done? -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-566-gf0198e : Latest paper written in org: https://arxiv.org/abs/2106.05096

table: problem with nan and if

2021-06-21 Thread Uwe Brauer
Hi I have the following table #+begin_src elisp #+NAME: test | Name | E1 | E2 | E3 | Result1 | Result2 | Final | |---+++-+-+-+---| | User1 ||| | | 8 | nan| | User2 ||| | | || | User3 | 1 |