Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 10 Mar 2016 09:32:56 +0100how to take a value close to a cell?https://ask.libreoffice.org/en/question/63567/how-to-take-a-value-close-to-a-cell/ how to take a value close to a cell
1) I have a cell A1 contains the surface 6 Ha
2) j'i another cell A2 contains the number of sector 12.5
for me I do not want half a sector that's why I've been looking at a close estimate fortunately libreofice allows feire ca with the cell formatting
the number becomes 13 this is great
Now I want to calculate the area of the sector and for that I must
divide the surface on the number of sector 13
but the problem libreoffice take the original value was 12.5 despite 13: '(Tue, 26 Jan 2016 22:42:17 +0100https://ask.libreoffice.org/en/question/63567/how-to-take-a-value-close-to-a-cell/Answer by JohnSUN for <p>how to take a value close to a cell</p>
<p>1) I have a cell A1 contains the surface 6 Ha
2) j'i another cell A2 contains the number of sector 12.5
for me I do not want half a sector that's why I've been looking at a close estimate fortunately libreofice allows feire ca with the cell formatting
the number becomes 13 this is great
Now I want to calculate the area of the sector and for that I must
divide the surface on the number of sector 13
but the problem libreoffice take the original value was 12.5 despite 13: '(</p>
https://ask.libreoffice.org/en/question/63567/how-to-take-a-value-close-to-a-cell/?answer=63599#post-id-63599 Try choose Tools - Options - LibreOffice Calc - Calculate and check [Precision as shown](https://help.libreoffice.org/index.php?title=5.0/Common/Calculate&Language=en-US&System=WIN&Version=5.0#bm_id3145766)
![Precision as shown](/upfiles/14539039231770222.png)Wed, 27 Jan 2016 15:13:56 +0100https://ask.libreoffice.org/en/question/63567/how-to-take-a-value-close-to-a-cell/?answer=63599#post-id-63599Comment by modo for <p>Try choose Tools - Options - LibreOffice Calc - Calculate and check <a href="https://help.libreoffice.org/index.php?title=5.0/Common/Calculate&Language=en-US&System=WIN&Version=5.0#bm_id3145766">Precision as shown</a></p>
<p><img alt="Precision as shown" src="/upfiles/14539039231770222.png"/></p>
https://ask.libreoffice.org/en/question/63567/how-to-take-a-value-close-to-a-cell/?comment=66078#post-id-66078yes that's what I look for long. thank you very much
+100Thu, 10 Mar 2016 09:32:56 +0100https://ask.libreoffice.org/en/question/63567/how-to-take-a-value-close-to-a-cell/?comment=66078#post-id-66078