I found out how to round numbers in a cell. Apparently the numbers still contain the exact number in the cell because when using the rounded number in a formula I get results one would obtain using the exact number. How can I get the number used in the formula to use the rounded number?

ROUND(YourFormula,n), where returned comma places depends on n.

=ROUND(22.111,0) returns 22. =ROUND(22.555,0) returns 23
=ROUND(22,111,2) returns 22,11 =ROUND(22,555,2) returns 22,56
=ROUND(22,-2) returns 20 =ROUND(25,-2) returns 30

@Arvi
In your second example line there seems to be some confusion between dots and commas, or am I missing something ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Nothing strange with this - I use commas in numbers, and semicolons as separators. In this post I corrected some such 'typos', but it looks like missed 2nd row ones.