It should come as no surprise to anyone who has read my blog for a while that I use Excel on a relatively regular basis. Wherever possible, I like using parameters, rather than addressing something directly. There are a few reasons for this. It makes a formula shorter, more user friendly, and quicker to write. I have a small spreadsheet, which shows some currencies and their relative exchange rates. I want to define an addressing parameter, rather than using the cell address. Here’s how:
(more…)