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
