Activity Based Depreciation If /Then VBA Code

[mrmmickle1]

I am attaching a workbook that contains activity based depreciation formulas.
I have written notes in it to explain the dilemma. I need to fill in a set of new values based on activity hours....
I was thinking that the user could input estimated activity hours with a userform and then based on that would fill in the chart. Once the userform is submitted and the chart is completed I need to run a set of if/then statements behind the values to evaluate if they are greater then residual value. IF they are I need to plug in a value... Does anyone have any ideas on how to simplify this process?

Any help and or suggestions/ideas would be much appreciated!

-Matt