| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Using a cell reference as part of a link | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| worksheet tab name as part of a cell reference | Excel Worksheet Functions | |||
| reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
