Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate cell reference
I need to calculate a cell reference with a formula.
For instance: Instead of using =D6 I need to have excel calculate the '6' portion -- like this =D&(COUNTIF(D6:D32,"<50")) so it will use the result of the function to determine the cell number. I have not been able to successfully reference a cell using a formula. Is this even possible? Thanks, Jesse |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate cell reference
have a look at INDIRECT function
-- Don Guillett SalesAid Software "Jesse Wiggins" wrote in message ... I need to calculate a cell reference with a formula. For instance: Instead of using =D6 I need to have excel calculate the '6' portion -- like this =D&(COUNTIF(D6:D32,"<50")) so it will use the result of the function to determine the cell number. I have not been able to successfully reference a cell using a formula. Is this even possible? Thanks, Jesse |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate cell reference
Don,
My ultimate goal is to have a graph query cells to find whether they meet a certain criteria to determine the 'data range' in the graph. I cannot seem to get the 'Source Data' window to let me use the INDIRECT function when defining a 'Data range'. I get the 'Reference is not valid.' error. My data range looks like this: =INDIRECT(Data!$F$25) Where F25 is a cell that calculates whether the values in a group of cells is "<50". The funny thing is that even though I get an invalid reference error, the graph preview displays correctly! Very aggrivating. "Don Guillett" wrote in message ... have a look at INDIRECT function -- Don Guillett SalesAid Software "Jesse Wiggins" wrote in message ... I need to calculate a cell reference with a formula. For instance: Instead of using =D6 I need to have excel calculate the '6' portion -- like this =D&(COUNTIF(D6:D32,"<50")) so it will use the result of the function to determine the cell number. I have not been able to successfully reference a cell using a formula. Is this even possible? Thanks, Jesse |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate cell reference
Jesse, you can use the INDIRECT worksheet function.
For example: If the value of A1 = 2, and the value of B2 = 100, then: =INDIRECT("B"&$A$1) Value of a reference in cell A1 would give you 100. -----Original Message----- I need to calculate a cell reference with a formula. For instance: Instead of using =D6 I need to have excel calculate the '6' portion -- like this =D&(COUNTIF(D6:D32,"<50")) so it will use the result of the function to determine the cell number. I have not been able to successfully reference a cell using a formula. Is this even possible? Thanks, Jesse . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Reference: won't auto-calculate, among other things | Excel Worksheet Functions | |||
How to calculate (generate) a cell reference | New Users to Excel | |||
Auto calculate absolute cell reference | Excel Discussion (Misc queries) | |||
Formula 'mis' calculate when reference cell contains a "0" | Excel Discussion (Misc queries) | |||
How to 'Calculate' an Excel Reference | Excel Discussion (Misc queries) |