Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a cell contain formula, how to extract value of that cell
a cell contain formula, I want to extract value of that cell with if( )
function without creating circular reference |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a cell contain formula, how to extract value of that cell
In cell A 1 I have put the number 1
In cell B 1 I have put the number 1 In cell C 1 I have put the following formula:- =(A1+B1) This shows the result of 2 in cell C 1. In cell D 1 I have put the following:- =C1 This puts the result on the formula in cell C 1 into cell D 1. I think that the above will give you what you want. Please hit Yes if my comments have helped. Thanks. "gdkons" wrote: a cell contain formula, I want to extract value of that cell with if( ) function without creating circular reference |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract portion of formula resident in a cell | Excel Worksheet Functions | |||
extract number and use in formula from text & numbers in cell | Excel Worksheet Functions | |||
how to extract data from a cell in a formula in another cell | Excel Worksheet Functions | |||
Formula to extract a phone# from a cell of text (eg classified)? | Excel Worksheet Functions | |||
How I can to extract a formula from other Cell Function? | Excel Discussion (Misc queries) |