Incremental for Lumber - IF function

[Red]

I have searched around for a solution, but I have yet to find one. I know it is more than likely something small I am overlooking. I am trying to get an expression to generate the length of a beam and provide the correct lumber length for imperial sized lumber.

For example: ( I use separate lines when writing expressions out. In my opinion, it is a lot easier to read)

( IFS (
{Property:Beam/Length Left} <= 8 ', 8 ',
{Property:Beam/Length Left} >= 8'-1", 10 ',
***when it get to this stage and beyond, I need a >= 8'-1" like above and then a <= 9'-11", 10'***
{Property:Beam/Length Left} >= 10'-1", 12 ',
{Property:Beam/Length Left} >= 12'-1", 14 ',
{Property:Beam/Length Left} >= 14'-1", 16 ',
{Property:Beam/Length Left} >= 16'-1", 18 ',
{Property:Beam/Length Left} >= 18'-1", 20 ' ) ) ), 0 )

I can get one to work with just an IF function, but I hit a roadblock when I try several entries.

[poco2013]

IFS ( {Property:Beam/Length Left} <= 8 ', 8 ',
{Property:Beam/Length Left} >= 8'-1", 10 ',
{Property:Beam/Length Left} >= 10'-1", 12 ',
{Property:Beam/Length Left} >= 12'-1", 14 ',
{Property:Beam/Length Left} >= 14'-1", 16 ',
{Property:Beam/Length Left} >= 16'-1", 18 ',
{Property:Beam/Length Left} >= 18'-1", 20 ' )

Too many parenthesis , also last value in ifs is always true
See help in "What's this"

[Red]

The issue that I am running into is with this setup, once I get past 10'-0", everything gets set as a 10'. Because technically everything is greater than 10'-1" past that mark unless I can set a range for each, pcs of lumber. I think it needs:

{Property:Beam/Length Left} >= 10'-1" OR {Property:Beam/Length Left} <= 11'-11", 12 '

However, I am formatting it wrong...

In what I posted earlier, I forgot to remove the extra parenthesis at the end, I was using several data conversion in another expression when I copied it.

[Red]

B001 is 8'-0" long and shows correctly at 8
B002 is 8'-1" long and shows correctly at 10
B003 is 10'-1" long and shows incorrectly at 10

[DGSketcher]

Rather than all the IFs try looking at it as a maths problem, see if this offers a better solution...

https://help.graphisoft.com/AC/24/INT/#t=_AC24_Help%2F045_PropertiesClassifications%2F045_Properties...

[Red]

The lightbulb in my head is slowly warming up....

[Red]

STR ( STRTONUM ( STRCALCUNIT ( MROUNDUP ( {Property:Beam/Length Left}, 24 " ) ) ), 0 )

[Red]

Autotext label with the formula...