Excel: How to fill a range of cells with a module

I have this IF statement:

=IF([Year]=2016,IF([Condition]="XClean",72,IF([Condition]="Clean",72,IF([Condition]="Average",72,IF([Condition]="Rough",72,0)))))

I have nested this IF statement 55 times in one cell, to fill a range of 11 years (from 2016-2005). I use the formula for multiple assignments. I was wondering if there was a way to create a module, where I can input a cell coordinate to replace [Year], input another cell coordinate to replace the [Condition], and a range for which I want the formula to populate. Assistance is much appreciated