Feature RequestsCeiling Function
Would it be possible to get a Ceiling Function from excel? This helps in determining the number of pieces needed when things are sold in increments other than 1. For example, and LVL can be sold in 2' increments, so the function Ceiling(Linear:ft,2) would always return the length rounded up to the nearest two feet. The round up function kind of does this if set up correctly, but not in every case. If I have a header that is 3 beams deep I could us this: Ceiling([Linear:FT],2)*[# of Pieces per Foot]. The final roundup function would only roundup the total lf of all three beams to the nearest 2 lf.
Try this formula. We use Math.js as our formula engine:
ceil([Linear:FT] / 2) * [# of Pieces per Foot]
@David, I'm just starting to dip into Math.js myself.
You might find this site helpful: Math.js Functions • Machinations Docs • Machinations.io
Thank you! Yes I didn't realize this was already a Math.js function, I will check out this link.