At 11:56 15/10/2012 -0400, James Knott wrote:
Brian Barker wrote:
Now you are assuming (1) that negative election results are possible,
I was just posting in reference to comment about negative numbers
and not the original post.
That makes your suggestion (of applying ABS() to the values) e
On 2012-10-16 04:11, Brian Barker wrote:
At 16:36 15/10/2012 +0200, Andreas Säger wrote:
Am 15.10.2012 16:20, Brian Barker wrote:
At 14:42 15/10/2012 +0200, Andreas Säger wrote:
Am 15.10.2012 09:49, Pertti Rönnberg wrote:
"if value in cell c3 is /_less than_/ '1' then d3 shall be '0',
else
Brian Barker wrote:
Now you are assuming (1) that negative election results are possible,
Well, with the way Romney's doing... ;-)
I was just posting in reference to comment about negative numbers and
not the original post.
--
For unsubscribe instructions e-mail to: users+h...@global.libr
At 16:36 15/10/2012 +0200, Andreas Säger wrote:
Am 15.10.2012 16:20, Brian Barker wrote:
At 14:42 15/10/2012 +0200, Andreas Säger wrote:
Am 15.10.2012 09:49, Pertti Rönnberg wrote:
"if value in cell c3 is /_less than_/ '1'
then d3 shall be '0', else (-- if c3 is '1'
or bigger then -- ) use
At 10:34 15/10/2012 -0400, James Knott wrote:
Andreas Säger wrote:
Am 15.10.2012 10:45, Brian Barker 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
Andreas Säger wrote:
Am 15.10.2012 10:45, Brian Barker 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, ...
The answer could be:
=IF(C3<
At 16:08 15/10/2012 +0200, Andreas Säger wrote:
Am 15.10.2012 10:45, Brian Barker 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, ...
At 14:42 15/10/2012 +0200, Andreas Säger wrote:
Am 15.10.2012 09:49, Pertti Rönnberg wrote:
"if value in cell c3 is /_less than_/ '1' then
d3 shall be '0', else (-- if c3 is '1' or
bigger then -- ) use the integer of value in c3)"
=MIN(0;INT(C3))
This is getting sillier! This formula does
Indeed. Which is why your last answer is also wrong!
On 15 October 2012 15:08, Andreas Säger wrote:
> Am 15.10.2012 10:45, Brian Barker 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