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. > > Brian Barker > >
Sorry, should be: =MAX(0;INT(C3)) -- 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
