Ask Your Question
0

how to take a value close to a cell?

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

modo 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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

Comments

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

modo gravatar imagemodo ( 2016-03-10 09:32:56 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 29 times

Last updated: Jan 27 '16