Excel - How to build a formula with part of the value coming from another cell
Posted on 2013-12-02
I have a completely basic formula in cell H2, for example: "=A2-B2"
Now I want to dynamically enter a letter in cell A1, e.g. "C" so that the result that I see in H2 is the difference between cell A2 and C2.
Or another way of asking the question: How can I modify my formula in H2 so that when I enter "C" into cell A1, the formula in H2 changes to "=A2-C2" ?
My bumbling attempt at trial-and-error for cell H2, in case it clarifies my question:
"=A2-(A1)2" No joy