Need help understanding a simple formula
This formula is for the height of a base filler. I unchecked "knotch for toe kick" and added .5 for scribe to floor.
=IF(Notch_For_Toe_Kick=1,Height-Toe_Kick_Height,IF(Filler_To_Floor=1,Height+Scribe_To_Floor,Height-Toe_Kick_Height))
The height is 28.5". If I read this formula right, the value should be 29, but it's not. It's 28 1/2".
Attached video shows the design data sheet and the formula check. The formula check indicates the value is 29. Yet, the value is 28 1/2. Can anybody shed some light on this discrepancy?
Toolbox BSB Survey
Have you been using Toolbox BSB? We'd love to hear what you think!
Take the Survey
MVU eLearning
Grow Your Knowledge
Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.
Follow us on:
ERP for Millwork Shops
Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.