# Calc will not use 'rounded up/down' numbers in formulas

The formula I am needing is based on the rounded 'up/down' number. Calc. will display the rounded number, however, it uses the original number (from before it was rounded) in the calculation of the formula being used in the cell. This ruins the calculation. Is there a way to change this?

You surely did not round, but format the display to a reduced number of decimal places.

Rounding is done by functions like ROUND(

Value; NumOfDecimalPlaces), ROUNDUP, ROUNDDOWN, TRUNC, INT, FLOOR, CEILING. Number formatting is done by format codes in the tab 'Numbers' when formatting cells.