Display values instead of cell ID's in formula and show them in another cell

[bengineer]

PLEASE HELP! or can it not be done?

I need to show my workings out for a project and the cell code e.g =A1*B1 is not enough. If A1=5 and B1=10 is there anyway to make it say =5+10 in the cell automatically based on the values of the cells it is referencing. Thanks in advance,

Ben

[mahju]

Hi
Try this one

Please Login or Register  to view this content.

Regards

[bengineer]

Hi thanks but thats a long process for more complicated forumlae. I want to be able to pick any cell easily and have it display the formula with cell values rather than A1 and B1 for example. With your method i would still have to source all cells i have orginially used to make the formula.