hello everyone
is there a way to show answer to other cell?
i want to type to a cell this:
12+5=
and show to next sell the answer
17
hello everyone
is there a way to show answer to other cell?
i want to type to a cell this:
12+5=
and show to next sell the answer
17
Select a cell, asay B1, and got to names, Ctrl-F3
Add a name of EVAL, and a refersto value of =EVALUATE(A1)
In A1 use, 12+5, not the =
In B1, =EVAL
you meen select a cell different from B1,A1?
what is asay?
what name should i add?
in B1 cell i will type =eval ?
thanks for your help
No, select a cell, let us SAY B1, and add the name as I showed. We are selecting B1 because the name is referring to A1, that is one cell to the left, so wherever you use EVAL it will pick up the value in the cell to its left. So, in H5, it will pick up theexpression in G5.
Example
Hi,
I tried the same..am not being able to create a reference...??
thank you very much!!!
type to A1 12+3
type to B1 =EVAL
select B1 and pressCtrl+F3
type as a name EVAL
press add name
type to refer to =EVALUATE(A1)
press ok