formula

New Contributor

if in cell b2 i add 3*5 then the i want my answer in b3 cell 

3 Replies

@tika2335 You can create a named formula, eg. called "result" where the formula is like this:

=EVALUATE(Sheet1!B2)

 

Then in B3, type =result

Screenshot 2021-12-20 at 08.41.38.png

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.

Screenshot 2021-12-21 at 06.31.38.png

That's where you enter the named formula as demonstrated  in the picture. I've attached the file.