I need a formula to calculate the amount of liquidated damages. I have what
is called the cost share amt. in one column, another column has the contract
year, another column has the conservation practice number. I need a formula
for a 4th column that will put a percentage, which it pulls from a chart in
the same workbook. The chart is set up by year and practice code to figure
the percentage of cost share that will be paid. And then I need a formula
that will figure out what the percentage amount is in dollars, which is the
liquidated damages.