>>> "FE" == Fraga, Eric writes: > I make extensive use of the advanced features of the spreadsheet in org > tables, specifically having a first column that indicates which rows > should be calculated or not. Check out the org info manual > (org) Advanced features Aha, thanks meanwhile I tried | | | What | | This | | |---+-------+-----------+-----------+-----------+-----------| | ! | | Account 1 | Account 1 | Account 2 | Account 2 | |---+-------+-----------+-----------+-----------+-----------| | | Item1 | 224999 | 56249.75 | 224999 | 56249.75 | | | Item2 | 269403 | 67350.75 | 269403 | 67350.75 | | | Item3 | | | | | | | Item4 | | | | | | | Item5 | 10300 | 2575.00 | | | #+TBLFM: $4=if(typeof(0.25*$3) == 12, string(""),0.25*$3); E f-2::$6=if(typeof(0.25*$5) == 12, string(""),0.25*$5); E f-2 Or / instead of !, the problem is then this row is not exported. So you propose | | | What | | This | | |---+-------+-----------+-----------+-----------+-----------| | | | Account 1 | Account 1 | Account 2 | Account 2 | | # | Item1 | 224999 | 56249.75 | 224999 | 56249.75 | | # | Item2 | 269403 | 67350.75 | 269403 | 67350.75 | | # | Item3 | | | | | | # | Item4 | | | | | | # | Item5 | 10300 | 2575.00 | | | #+TBLFM: $4=if(typeof(0.25*$3) == 12, string(""),0.25*$3); E f-2::$6=if(typeof(0.25*$5) == 12, string(""),0.25*$5); E f-2 Which works nicely, thanks -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against the Ukraine. I support to deliver weapons to Ukraine's military. I support the ban of Russia from SWIFT. I support the EU membership of the Ukraine. https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/