Andreas Säger 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.
ABS(INT(C3))
--
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
