khaledocom
09-03-2011, 08:17 AM
Hi all,
An example:
in c1 there's a formula = a1+b1
a1=10 and b1=20 then value in c1 should be 30.
My question: is it possible to make the first value captured by formula in c1 not to change (fix the value by using a sort of formulas)
later I'll change value in a1 and b1 but I want c1 to remain as it is 30.
Can it be done without using vba or not?
BY the way the original formula was as follows:
=MID(MID(F1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},F1&"0123456789",FIND("[",F1,1))),255),1,6)+1-1
An example:
in c1 there's a formula = a1+b1
a1=10 and b1=20 then value in c1 should be 30.
My question: is it possible to make the first value captured by formula in c1 not to change (fix the value by using a sort of formulas)
later I'll change value in a1 and b1 but I want c1 to remain as it is 30.
Can it be done without using vba or not?
BY the way the original formula was as follows:
=MID(MID(F1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},F1&"0123456789",FIND("[",F1,1))),255),1,6)+1-1