On Tue, Oct 01, 2024 at 10:01:18PM +0200, jman wrote:
> <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----------

Glad you found it :)

Cheers
-- 
t