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
|