I am using text formatting in a formula. Per attached XLS, the combination of cell referencing and text formatting results in some erroneous output.
That is, cell range H2:H4 has input values. Once I include these references, however, the cell output differs. The attached XLS provides more detail on this issue.
My question: Is there anything wrong with the **formatting** (text in formula) that causes the incorrect output? If so, how can this be fixed?