Forum Discussion
formula
if in cell b2 i add 3*5 then the i want my answer in b3 cell
tika2335 You can create a named formula, eg. called "result" where the formula is like this:
=EVALUATE(Sheet1!B2)
Then in B3, type =result
Note that the EVALUATE function is an old Excel 4.0 macro function. Your file needs to be saved as an xlsm file for it to work.
SIR I NEED MORE DETAILS
tika2335 On the Formula ribbon, you'll find the Name Manager.
That's where you enter the named formula as demonstrated in the picture. I've attached the file.