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?
MVU eLearning
Grow Your Knowledge
Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.