showing formula as text string rather than result

1. showing formula as text string rather than result

Hi, When importing data into my spread sheet i wondered is it possible to show the formula which produced the result rather than the result as a text string.

Eg

if i have a cell lets say b257 in on sheet giving a result of say 60%
can i get this cell into another sheet but rather than show 60% show the formula that produced the result ie IF(AND(AB5=1,N5>O5,AJ5=1),1,IF(AND(AB5=-1,N5<O5,AK5=-1),-1,0)) as a text string or similar

The reason being i wish to look at which formulas are producing the best results and hopefully see common elements in these formulas to produce further improvements for eg lets say the above formula produces a 60% result and another 3 formula containin AB produce good results then i could reason that ab is a significant input

hope someone can help

2. posting value as string

i have made some progress on this using the =GETFORMULA(BB274)
my problem is slightly diff now

the formula i want to display is in another part of the spread sheet
so when i use the getformula(BB274) it returns =eo277 . this is the cell i want to get the formula for i have eliminated the = but can not work out the syntax to do what i want which is in fact this

=GETFORMULA(BB274) which gave =eo257
=RIGHT(BB279,5) which gives eo257 (to get rid of =) in cell bb280

now what i wanted to do is get the formula in cell eo257 but this is where i have the problem

if try =GETFORMULA(BB280) obviously i get =right(bb279,5)
i tried a sort of nested getformula ie =getformula((getformula(right(bb279,5)))
with no joy .

What i want is to put the eo257 into the getformula
any ideas
thank you

3. Try:

=INDIRECT("'"&getformula(right(bb279,5)))

(I haven't tested this)

4. getformula

no did not work got value in cell

5. right seems a dubious function to use as your length may change and so the 5 may be wrong

=mid(GETFORMULA(BB274) ,2,1000)

getformula(mid(GETFORMULA(BB274) ,2,1000))

nb getformula is not in my computer so I can not test it!

Does that work

Regards

Dav

6. get formula

hi the 1st equation works and returns the result eo257 but the second formula does not and produces #value
thank you for trying

7. perhaps

getformula(indirect(mid(GETFORMULA(BB274) ,2,1000)))

any better?

Regards

Dav

8. showing formula as text

works great thank you

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1