Using a cell in formula to create a reference
Thank you... I think this will work, however you're using a characters I am
not familiar with. What is the quotation command " and what is it doing in
this function?
Thank you for your assistance!
"Elkar" wrote:
It should still work, just place the INDIRECT function inside of your SLOPE
function. Something like:
=SLOPE(INDIRECT(A8&B8&":"&A9&B9),$DK9:$DK94)
This assumes that cells A8:B9 contain the following:
A B
8 D 9
9 D 94
HTH,
Elkar
"ek" wrote:
Thank you... however i am trying to use a formula such as this:
=SLOPE(D9:D94,$DK9:$DK94)
Rather than reference D9:D94 in the formula, I'd like to be able to
reference cells with the text "D9" and "D94". That way i will be able to
change calculations on the fly and easy see the inputs. ANy ideas? Thank you.
"Elkar" wrote:
Try this:
=INDIRECT(A8&B8)
HTH,
Elkar
"ek" wrote:
Below is a sample of a spreadsheet that I am using. The top part is my "raw
data area", and the bottom part is my "calculation area". I want to create a
formula in C8 that references A8 for the column, and B8 for the row. So when
I drag C10 down it will reference A11 and B11, etc. Can anyone help me? Thank
you.
A B C
1 Data Area
2 Red Yellow
3 Blue Green
4 Purple Orange
5 Pink Black
6 Calculation area
7 Column Row Response
8 A 3 Red
9 B 3 Yellow
|