Indeed. Which is why your last answer is also wrong! On 15 October 2012 15:08, Andreas Säger <[email protected]> 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: [email protected] > 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: [email protected] 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
