Solved

Excel - How to build a formula with part of the value coming from another cell

Posted on 2013-12-02
4
388 Views
Last Modified: 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

Thanks
0
Comment
Question by:Dwight Baer
  • 2
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39690641
=a2-indirect(A1 & "2")
0
 

Author Comment

by:Dwight Baer
ID: 39690674
Wonderful.  One little thing more ...
How can I modify that so that I can  copy it?  When I copy it into H3, for example, I need to formula to read "=a3-indirect($A$1 & "3")

Thanks again.
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39690682
"=a3-indirect($A$1 & row())
0
 

Author Comment

by:Dwight Baer
ID: 39690694
Fantastic!!  Thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question