Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell reference
Result of a formula is in a format of cell reference (ex: c5) which i want to
use in another formula. But the formula where I am using the cell reference is not treating the same as a cell reference. can anybody help me ? |
#2
|
|||
|
|||
cell reference
Play around with this...
Place a cell reference in cell A1 - using your example place the text string c5 in cell A1... Now place a value in cell c5 - say you put the number 100 in c5 Now use the following formula in any other cell to pull the value of cell c5 based upon the reference in cell A1... =VALUE(INDIRECT(A1,TRUE)) -- Thanks for your help - Joe Mac "jan" wrote: Result of a formula is in a format of cell reference (ex: c5) which i want to use in another formula. But the formula where I am using the cell reference is not treating the same as a cell reference. can anybody help me ? |
#3
|
|||
|
|||
cell reference
You need INDIRECT, Jan.
http://www.officearticles.com/excel/...ft_excel.h tm ************ Anne Troy www.OfficeArticles.com "jan" wrote in message ... Result of a formula is in a format of cell reference (ex: c5) which i want to use in another formula. But the formula where I am using the cell reference is not treating the same as a cell reference. can anybody help me ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
Tab name / reference cell? | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |