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

[jman]

<tomas@tuxteam.de> 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---------s----------
| EUR |    USD | Exchange rate |
|-----+--------+---------------|
|  10 |   8.97 |         0.897 |
|  15 | 13.455 |               |
#+TBLFM: $2='(* $1 @2$3);N
----------e---------e----------

Best,