[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] empty cells in columns should be left emtpy when manipulating co
From: |
Uwe Brauer |
Subject: |
Re: [O] empty cells in columns should be left emtpy when manipulating columns |
Date: |
Thu, 22 Jun 2017 07:56:23 +0000 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/26.0.50 (gnu/linux) |
> Hello,
> Uwe Brauer <address@hidden> writes:
> One possibility:
> | 3.25 | 0.4875 |
> | | |
> | 2.25 | 0.3375 |
> #+TBLFM: $2=if("$1" == "nan", string(""), $1*0.15);E
Great but how can I round?
#+TBLFM: $2=if("$1" == "nan", string(""), $1*0.15;%.1f);E
And friends did not work any more
| 3.25 | 0.5) |
| | 0.0) |
#+TBLFM: $2=if("$1" == "nan", string(""), $1*0.15;%.1f);E