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

[Guest]

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

 

[Guest]

Try

INDIRECT(C22)/F33

 

[Guest]

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

 

[Guest]

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?

 

[Guest]

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?

 

[Guest]

=INDIRECT("$A"& AN22)

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

Is this what you require?

 

[Guest]

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

You are really a kind person.

I owe you one

 

[Guest]

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

 

[Guest]

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