If you are ready to undertake a one-time exercise, you could define a named range (say 'Multiplier') and change all your cells to read as Cell_Value*Multiplier
This will enable your boss to run calaculations by just changing the one cell!
Some help and reading on named ranges below
http://www.contextures.com/xlNames01.html
Bookmarks