Custom Formulas

  • Custom Formulas

    Posted by Doug McLean on June 15, 2021 at 10:13 am

    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

    Troy DeGroot replied 1 year, 2 months ago 2 Members · 1 Reply
  • 1 Reply
  • Troy DeGroot

    Organizer
    June 16, 2021 at 8:55 am
    Points: 11,545
    Rank: UC2 Brainery Blue Belt I UC2 Brainery Blue Belt I

    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.