Basic Excel: How to show an interval in a cell rather than a single number
<p>I want to make a column that lists a +or- 5%variance of a certain calculation.
For example, in column A and B there are a list of numbers and I want column C to show ColumA/ColumnB + or - 5%.</p>

<p>So if <code>A1 = 10</code> and <code>B1 = 12</code> then I want <code>C1</code> to show "<code>.792 to .875</code>" or something like "<code>.792 - .875</code>" or "<code>(.792,.875)</code>".</p>

<p>In order to make it easy to look at, maybe I want a certain format that would change the colors of the 95% # and the 105% number ...
What would one do in these kind of situation?</p>