Ceiling and Floor Functions

[andersonreyesortiz]

It should be usefull be able to use Ceiling and Floor functions as in Excel. But in Revit Calculated Values for schedules tool.

Sometimes for fabrication we need round to the nearest 0.5, for example 2.35 rounded to 2.50, 3.85 rounded to 4.00.

[Ric_Weber]

Is this what you're looking for?  See both responses to the inquiry on this forum post: https://forums.autodesk.com/t5/revit-architecture-forum/parameter-formula-to-round-to-nearest-0-5/td...

[andersonreyesortiz]

Hello @Ric_Weber thanks for your suggestion.

I made some tests using that option before posting this idea.

Unfortunately that solution did not work for me.

The Excel CEILING function rounds a given number UP to the nearest multiple of a specified significance

And the Excel FLOOR function rounds a fiven number DOWN. That's what I need specify in muy formulas.

[Ric_Weber]

I am fairly decent at Excel and I had never heard of those functions in Excel before.  I hadn't realized that you were talking about real functions.  That is great!