At 21:13 15/10/2012 +0300, Pertti Rönnberg 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, and for the value of this
cell to be changed, since, for example, 5,77 would become equal to 5?
The answer could be:
a >>write following formula in(e.g.)cellD3" =IF(c3<1;0;INT(c3))"
When I tried to give an answer to Gilles' basic
question I proposed "my" formula based on the
reality that I have never experienced negative
voting. The very interesting (theoretical)
discussion this caused shows that there may be several correct solutions.
I can imagine that Gilles (and me too) is
curious to know what is the best answer to his
problem. Even if I did (I admit) some
"overthinking" I cannot see that my answer is wrong.
No, your answer was not wrong, but it was
unnecessarily complicated - like adding zero to
something: not wrong but pointless and
confusing. For non-negative C3,
"=IF(C3<1;0;INT(C3))" is identical to and no better than "=INT(C3)".
So, what is the best way for Gilles to continue?
Using INT(), as was suggested in the very first
reply (before any of my comments).
Brian Barker
--
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
