PDA

View Full Version : right formula



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..

mikerickson
03-19-2012, 10:27 PM
You can do this with names. Select a cell in row 1 and define

Name: colAFormula
RefersTo: =GET.CELL(6, Sheet1!$A1)

Then the formula =colAFormula in a cell will return a string of the formula in column A of the same row as the cell holding the formula.