Re: spreadsheet formulas without a .

[Uwe Brauer]

>>> "DG" == Dov Grobgeld  writes:

> You can do the following:
> #+TBLFM: $3=$1*$2;%.0f

> Search for % at https://orgmode.org/manual/Formula-syntax-for-Calc.html .

Thanks, this was the link I was looking for.

Uwe 


smime.p7s
Description: S/MIME cryptographic signature

Re: spreadsheet formulas without a .

[Dov Grobgeld]

You can do the following:

#+TBLFM: $3=$1*$2;%.0f

Search for % at https://orgmode.org/manual/Formula-syntax-for-Calc.html .

Regards,

On Mon, Aug 24, 2020 at 12:03 PM Uwe Brauer  wrote:

>
> Hi
>
> Please look at
>
>
> | 20 | 0.9 | 18. |
> #+TBLFM: $3=$1*$2;f0
>
>
> I'd prefer to have the result 18, just written 18 and not 18.
>
> I can't the right format in the documentation.
>
> Thanks and regards
>
> Uwe Brauer
>
>
>

spreadsheet formulas without a .

[Uwe Brauer]

Hi 

Please look at 


| 20 | 0.9 | 18. |
#+TBLFM: $3=$1*$2;f0


I'd prefer to have the result 18, just written 18 and not 18.

I can't the right format in the documentation.

Thanks and regards

Uwe Brauer