# How do you use a roundup() formula in Writer?

I'm trying to create a table with a few complex calculations. I know all the formulas for 'calc', but alas, they do not function in Writer. The document I'm creating is predominantly text, I just need a few tables. I'd prefer to find a way to do it in the tables created on Writer and not import sheets from 'calc' so if there is a way to directly bring over the formulas, that would be preferable.

Roundup(value) can be emulated in Writer by "=(value + 0.5) ROUND 0".

Would "=(value + 0.5) ROUND 0" not also round 1.0 to 2.0 etc. While Roundup of 1.0 should remain at 1.0.

I have not used formulas in writer, but in basic I have used "=(-INT(-C5))" when the roundup function is not available.

Lol, yes, that's true.

Unfortunately that will not work, though I thank you for the response. A great deal of the numbers will naturally be whole numbers, so adding to the value will create rounding of numbers that are already whole.

I mixed that up with INT(X+0.5) if you didn't have a ROUND function. My bad.

If you have an INT function in writer then use "=(-INT(-C5))", this does not change existing whole numbers.