>>> "Uwe" == Uwe Brauer writes: > Hi > I have tables (several hundred rows) like this > | 03217428 | 3217428 | | > | 71310606 | 71310606 | | > | 05944371 | 5944371 | | > | 70086251 | 70086251 | | > | 50325182 | 50325182 | | > | 04559101 | 4559101 | | > | 51005420 | 51005420 | | > | 51141846 | 51141846 | | > | 05448640 | 5448640 | | > | 06602597 | 6602597 | | > #+TBLFM: $3=if("$1" == "$2", string("OK")) > So I would like to add a new column, which would return OK, if the > strings of each row of the to columns coincide. I tried > #+TBLFM: $3=if("$1" == "$2", string("OK")) > But it did not work. I googled and looked up the manual, no help. > It seems a common problem for spreadsheet so I presume there must be an > solution but I am unable to find it and would appreciate any help. > Thanks > Uwe Brauer The following seems to work | 03217428 | 3217428 | NO | | 71310606 | 71310606 | OK | | 05944371 | 5944371 | NO | | 70086251 | 70086251 | OK | | 50325182 | 50325182 | OK | | 04559101 | 4559101 | NO | | 51005420 | 51005420 | OK | | 51141846 | 51141846 | OK | | 05448640 | 5448640 | NO | | 06602597 | 6602597 | NO | | 8 | 9 | NO | | Hallo This | Hallo This | OK | #+TBLFM: $3=if("$1" == "$2", OK, string("NO"))