How to round to next hundred? Calc

English
#1

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

4083 $4100
5483 $5500
7333 $7300

#2

Hello,

have look at this documentation:

https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ROUNDUP_function

#3

On the LibreOffice help:

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

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

#4

=MROUND(A1,100)

#5

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.