Re: Fwd: Re: [libreoffice-users] Integer part of a number

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: users+help@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