General Questions
This is a great place to ask those general questions that don’t fit in other specific groups.
Organizer:
- Organized by
-
-
Custom Formulas
-
Custom Formulas
Does anyone have some info on how things like the Round, Ceiling, and Floor functions work when writing a formula for a custom column?
They don’t have the same syntaxes as those functions do in Excel and I can’t find any literature.TIA
-
1 Reply
-
Points: 20,929Rank: UC2 Brainery Brown Belt
Within a formula, I will add 0.4 to round up, then set the answer to a whole number. This way .2 becomes .6 and rounds up. If you have .8 it will become 1.2 and round down. I hope this makes sense. One thing to also think about is when to round up. I recently built tools that rounded up each length to a quantity of product units. It was important to assume the waste wasn’t used again. With 12′-0″ J-Channel they needed 3 sticks to cover 30′-0″. So we rounded up there instead of rounding the total linear footage and coming up with 30- 6′-0″ scraps to complete the project.
Log in to reply.