Re: [Question] Getting cell value and use it in table formula

On Tue, Oct 01, 2024 at 10:01:18PM +0200, jman wrote: > writes: > > > I think it's in the manual (this is Org v9.7): > > > > | 3.5.3 Emacs Lisp forms as formulas > > | -- > > For some reason, I think I got confused by the table formula modifiers > (E, N, L) and

Re: [Question] Getting cell value and use it in table formula

writes: I think it's in the manual (this is Org v9.7): | 3.5.3 Emacs Lisp forms as formulas | -- For some reason, I think I got confused by the table formula modifiers (E, N, L) and various type casting. What I wanted to achieve was simply: --s-

Re: [Question] Getting cell value and use it in table formula

On Tue, Oct 01, 2024 at 04:35:47PM +0200, jman wrote: > > Hello there, > > Let's look at the following table: > > --s-s-- > | EUR |USD | Exchange rate | > |-++---| > | 10 | 8.97 | 0.897 | > | 15 | 13.455 | | > #+TBLFM:

[Question] Getting cell value and use it in table formula

Hello there, Let's look at the following table: --s-s-- | EUR |USD | Exchange rate | |-++---| | 10 | 8.97 | 0.897 | | 15 | 13.455 | | #+TBLFM: $2='(* (string-to-number $1) (string-to-number (org-table-get 2 3)))