Example: You could set up a table to return the waste percentage for footing concrete to a formula based on the width and depth of the footing.

In this example, the input values show the largest width and depth for each range. Lengths and depths that are out of range (above the threshold for the dimension) return a value of zero.