Example: You could set up a table to return the weight of rebar to a formula based on the rebar size specified at takeoff.

In this example, the input values show the largest size for each range. Sizes that exceed the largest input value are out of range and return a value of zero. For example, if you enter 3.000 for Rebar Size, the table returns 0.376. If you enter 3.500 or 4.000, the table returns 0.668.