Ask Your Question
0

How to round to next hundred? Calc

asked 2016-10-29 20:50:30 +0200

merlysys gravatar image

Need to make results in first column into what are shown in second column

4083 $4100 5483 $5500 7333 $7300

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2016-10-29 21:09:17 +0200

Craig22 gravatar image

Hello,

have look at this documentation:

https://wiki.openoffice.org/wiki/Docu...

edit flag offensive delete link more
0

answered 2016-10-29 23:55:15 +0200

m.a.riosv gravatar image

updated 2016-10-29 23:56:04 +0200

On the LibreOffice help:

https://help.libreoffice.org/Calc/Mat...
=ROUND(number;-2)

to round to the nearest multiple of another number.
https://help.libreoffice.org/Calc/Mat...

edit flag offensive delete link more
0

answered 2016-11-05 18:16:58 +0200

adam1969in gravatar image

=MROUND(A1,100)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-29 20:50:30 +0200

Seen: 1,124 times

Last updated: Nov 05 '16