At 21:13 15/10/2012 +0300, Pertti Rönnberg wrote:
At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:
On 14.10.2012 12:20, Gilles SICHE wrote:
could anyone tell me which formula I should
use for the integer part of a cell to be shown
in another cell, and for the value of this
cell to be changed
: Re: [libreoffice-users] Integer part of a number
Date: Mon, 15 Oct 2012 10:49:51 +0300
From: Pertti Rönnberg
To: users@global.libreoffice.org
Good morning Gilles & others,
Provided that I got your problem right,
I think the answer is:
SumVotes_group1 = 5,78(in Calc e.g
At 12:38 15/10/2012 +0100, Tom Davies wrote:
... but Pertti's answer deals with unexpectedly wrong counts.
It does nothing of the sort, of course.
Brian Barker
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-l
;Sent: Monday, 15 October 2012, 9:45
>Subject: Re: [libreoffice-users] Integer part of a number
>
>At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:
>>On 14.10.2012 12:20, Gilles SICHE wrote:
>>>could anyone tell me which formula I should use
>>>for the
At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:
On 14.10.2012 12:20, Gilles SICHE wrote:
could anyone tell me which formula I should use
for the integer part of a cell to be shown in another cell, ...
The answer could be:
=IF(C3<1;0;INT(C3))
You are overthinking the problem: if C3 is posit
Good morning Gilles & others,
Provided that I got your problem right,
I think the answer is:
SumVotes_group1 = 5,78(in Calc e.g. in cellC3)
SumVotes_group2 = 7,34(in C4)
SumVotes_group3= 0,78(in C5)
SumVotes_ group4= 0,99(in C6)
The answer could be:
a >>write following formula in(e.g.)cell
correctly.
Regards from
Tom :)
--- On Sun, 14/10/12, Rolf Lochbühler wrote:
From: Rolf Lochbühler
Subject: Re: [libreoffice-users] Integer part of a number
To: users@global.libreoffice.org
Date: Sunday, 14 October, 2012, 11:48
> could anyone tell me which formula I should use for the integer p
> could anyone tell me which formula I should use for the integer part of a
> cell to be shown in another cell,
The function you're probably looking for is INT().
Example:
A1: 0.77
B1: =INT(A1) → 0
C1: =A1*2 → 1.54
D1: =B1*2 → 0
> and for the value of this cell to be
> changed, s
On 10/14/2012 05:20 AM, Gilles SICHE wrote:
Hello,
could anyone tell me which formula I should use for the integer part of a
cell to be shown in another cell, and for the value of this cell to be
changed, since, for example, 5,77 would become equal to 5?
When finding out who won in an election,
Hello,
could anyone tell me which formula I should use for the integer part of a
cell to be shown in another cell, and for the value of this cell to be
changed, since, for example, 5,77 would become equal to 5?
When finding out who won in an election, if one group or party gets a
result of 5,28,
10 matches
Mail list logo