I have a worksheet that I calculate various states fees for my work. There are different rules for each state, for instance TX is the total sale X 0.1304348 or 20.00 flat fee whichever is greater. I created my workbook with a chart that has 5 rules, one rule in each column. I need to return the rule that is applicable. My issue is that some states have multiple rules like per square foot or % of sale whichever is greater, some have simple rules like just 15%. I need to look at each rule and determine if it is blank, which means I would move to rule 2 etc. You will note some say manual these need to return manual. In the case there are two rules that apply it is the greater.
This might make more since when you look at the sheet.