> Hi,

> Uwe Brauer <oub@mat.ucm.es> writes:


> This works for me:

>    #+TBLFM: $2=if(typeof(remote(table2, @@#$7)) == 12, string(""), remote(table2, @@#$7)); E

Thanks very much!

> (everything is documented here:
>    https://orgmode.org/manual/Formula-syntax-for-Calc.html#Formula-syntax-for-Calc
> )

> This works too, although I'm not sure it should:

>    #+TBLFM: $2=if("remote(table2, @@#$7)" = "nan", string(""), remote(table2, @@#$7)); E

This I tried but without the " in front of remote

$2=if(remote(table2, @@#$7)" = "nan", string(""), remote(table2, @@#$7)); E


And obtained an error. I think I will stick to the typeof syntaxes.

Uwe