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
Bookmarks