wilg
03-19-2012, 05:44 PM
is it possible to return the right text formula from the formula in a cell?
right(j42,1)
in cell j42 there is a formula
=Sheet1!c1/2
I want to know if the formula is /2 or if another value like /4
I cant use the value returned refrencing sheet1 as i want a generic formula that I can use over many sheets that will change the sheet ref, thats why i only want to know if the formula is /2, or /4.
Let me know if I need to clarify further..
right(j42,1)
in cell j42 there is a formula
=Sheet1!c1/2
I want to know if the formula is /2 or if another value like /4
I cant use the value returned refrencing sheet1 as i want a generic formula that I can use over many sheets that will change the sheet ref, thats why i only want to know if the formula is /2, or /4.
Let me know if I need to clarify further..