Ask Your Question

how to take a value close to a cell? [closed]

asked 2016-01-26 22:42:17 +0100

modo gravatar image

updated 2020-08-29 12:21:54 +0100

Alex Kemp gravatar image

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: '(

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-29 12:22:02.718324

1 Answer

Sort by » oldest newest most voted

answered 2016-01-27 15:13:56 +0100

JohnSUN gravatar image

Try choose Tools - Options - LibreOffice Calc - Calculate and check Precision as shown

Precision as shown

edit flag offensive delete link more


yes that's what I look for long. thank you very much +100

modo gravatar imagemodo ( 2016-03-10 09:32:56 +0100 )edit

Question Tools

1 follower


Asked: 2016-01-26 22:42:17 +0100

Seen: 34 times

Last updated: Jan 27 '16