Re: [libreoffice-users] Re: Integer part of a number

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 (-- 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 not match the definition 
> > > above - and indeed for non-negative C3 is identically zero!  Try
> > > =0
> > > instead.
> >
> > Sorry, should be:
> > =MAX(0;INT(C3))
>
> Again, for positive C3, that is identical to
> =INT(C3)
> - which was suggested by someone a long way earlier in this thread!
>
> Brian Barker
Were there negative voters, you could use =TRUNC(C3).
This has been an interesting discussion because I have learnt that 
INT(-1.1) is 2 and if I want the integer part of -1.1 I need to use TRUNC.
INT returns the next integer less than or equal to the value. TRUNC 
returns the integer part of the value (in the format I have shown).
steve


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted