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

Indeed. Which is why your last answer is also wrong!

On 15 October 2012 15:08, Andreas Säger <villeroy@t-online.de> 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<1;0;INT(C3))
> >
> > You are overthinking the problem: if C3 is positive, that's no different
> > from
> > =INT(C3)
> >
> > Brian Barker
>
> Reportedly, negative numbers do exist.
>
>
> --
> 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

-- 
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