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
--
For unsubscribe instructions e-mail to: users+h...@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