Is there a way to insert a formatted calculation into Excel 2010 without using an image?
Posted
by
Ryan Taylor
on Super User
See other posts from Super User
or by Ryan Taylor
Published on 2012-03-29T15:03:49Z
Indexed on
2012/03/29
17:33 UTC
Read the original article
Hit count: 279
formatting
|excel-2010
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?
© Super User or respective owner