I recently had to do a bunch of currency conversion for my tax accounting. I had hundreds of transactions, and I needed to set the right exchange rate for each

I recently had to do a bunch of currency conversion for my tax accounting. I had hundreds of transactions, and I needed to set the right exchange rate for each transaction, based on the date of the transaction. This took just a couple of minutes to do in Excel. The solution - a simple Excel formula that compared two rows – was indeed, extremely elegant. Excel enables this type of elegant calculating all the time.