I am maintaining a list of database column names, notes, and their calculations in an Excel 2010 spreadsheet. The calculations are included so as to document how to derive the values for the various columns and not for calculations within the spreadsheet.
I have been entering the calculations into the cells simply as unformatted text like so:
100 - ((FiscalYearRegionConsumption - BaselineRegionConsumption) / (GoalRegionConsumption - BaselineRegionConsumption)) * 100
However, for long and/or complex calculations this could become rather unreadable. To improve readability and comprehension I would like to "pretty" print the calculation in an Excel cell. This would result in formatting that would like like this:
The only solution I have come up with is to:
- Write the calculation in another application such as Word
- Take a screenshot of said calculation
- Past the screenshot into Excel
The primary concern with this approach is maintenance. Should the calculation change or need correction I have to update two different sources of information.
Is there a better way included a formatted calculation into an Excel cell?