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

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.

formula | Microsoft Community Hub

3 Replies

Riny_van_Eekelen
Platinum Contributor
Dec 19, 2021
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.
- tika2335
  Copper Contributor
  Dec 20, 2021
  SIR I NEED MORE DETAILS
  - Riny_van_Eekelen
    Platinum Contributor
    Dec 20, 2021
    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.
    eval.xlsm10 KB

Forum Discussion

formula