No not what I was looking for. For example someone inputs 200 sqft in the form. I have a column that need to calculated the fee for removing existing flooring. I have a two part column with a fee structure depending upon the square footage.
Here is an example of the table:
If someone enters 200 the removals cost would be the the first row since it is less than 300. The value I am trying to acheive is “square footage” (that they entered in the form) multiplied by the “Removals cost” that is applicable. In this case it would be 4.
Anything above the last row item would just fall on the last row cost.