2012 Archives by date, by thread · List index

# 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?
```
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
```