Using the result of formula as part of reference to a cell in form
 

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all

Using the result of formula as part of reference to a cell in form
 

Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all

Using the result of formula as part of reference to a cell in form
 

1. you have explained it very well
2. your goal is very smart and can be applied to links, hyperlinks, as well
as cell references

=INDIRECT(C22)/F33

--
Gary''s Student - gsnu200718

Using the result of formula as part of reference to a cell in
 

Thanks Toppers, but in the following formula:

=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15

what should I have to type instead of 15?

I have a cell "AN22" that has the number I want 15.

How do I do?

"Toppers" wrote:

Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all

Using the result of formula as part of reference to a cell in
 

Thanks Gary, but what I do with this formula?

=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15

I want to change the 15, I have the number in a cell " AN22" and I want to
use it instead of the 15

How I do that?

"Gary''s Student" wrote:

1. you have explained it very well
2. your goal is very smart and can be applied to links, hyperlinks, as well
as cell references

=INDIRECT(C22)/F33

--
Gary''s Student - gsnu200718

Using the result of formula as part of reference to a cell in
 

=INDIRECT("$A"& AN22)

will refer to $A15 i.e. the value in $A15

Is this what you require?

"Victor" wrote:

Thanks Toppers, but in the following formula:

=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15

what should I have to type instead of 15?

I have a cell "AN22" that has the number I want 15.

How do I do?

"Toppers" wrote:

Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all

Using the result of formula as part of reference to a cell in
 

Thanks, you are a mindpace maker.
I will be able to sleep tonight.

You are really a kind person.

I owe you one

"Toppers" wrote:

=INDIRECT("$A"& AN22)

will refer to $A15 i.e. the value in $A15

Is this what you require?

"Victor" wrote:

Thanks Toppers, but in the following formula:

=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15

what should I have to type instead of 15?

I have a cell "AN22" that has the number I want 15.

How do I do?

"Toppers" wrote:

Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all

Using the result of formula as part of reference to a cell in
 

Good night from the UK! And thanks for the feedback.

"Victor" wrote:

Thanks, you are a mindpace maker.
I will be able to sleep tonight.

You are really a kind person.

I owe you one

"Toppers" wrote:

=INDIRECT("$A"& AN22)

will refer to $A15 i.e. the value in $A15

Is this what you require?

"Victor" wrote:

Thanks Toppers, but in the following formula:

=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15

what should I have to type instead of 15?

I have a cell "AN22" that has the number I want 15.

How do I do?

"Toppers" wrote:

Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all

Using the result of formula as part of reference to a cell in
 

Good night from spain, and, hey it's been my pleasure

"Toppers" wrote:

Good night from the UK! And thanks for the feedback.

"Victor" wrote:

Thanks, you are a mindpace maker.
I will be able to sleep tonight.

You are really a kind person.

I owe you one

"Toppers" wrote:

=INDIRECT("$A"& AN22)

will refer to $A15 i.e. the value in $A15

Is this what you require?

"Victor" wrote:

Thanks Toppers, but in the following formula:

=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15

what should I have to type instead of 15?

I have a cell "AN22" that has the number I want 15.

How do I do?

"Toppers" wrote:

Try

INDIRECT(C22)/F33

"Victor" wrote:

Hello dears, I need to use the result of a formula as a part of a reference
in another formula.
I have a formula that the result is a direction, ex: $A15 is the result of a
formula in the cell "C22" and I want to use it in another formula, ex:
$A15/F33. So I want to use the result in cell C22 to autoupdate all fromulas
that have that reference.
If I write C22/F33 gives ne an error. I want to use the result of the cell
C22 as the reference.

Any help? I know is not very well explained but...

Thanks to all