[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: |
Nicolas Goaziou |
Subject: |
Re: [O] empty cells in columns should be left emtpy when manipulating columns |
Date: |
Thu, 22 Jun 2017 09:34:56 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/25.2 (gnu/linux) |
Hello,
Uwe Brauer <address@hidden> writes:
> Please consider this
>
> | 3.25 | 0.4875 |
> | | 0. |
> | 2.25 | 0.3375 |
>
> #+TBLFM: $2=$1*0.15
>
> How can I avoid the entry 0. ?
One possibility:
| 3.25 | 0.4875 |
| | |
| 2.25 | 0.3375 |
#+TBLFM: $2=if("$1" == "nan", string(""), $1*0.15);E
Regards,
--
Nicolas Goaziou