Hello,
I have seen a useful trick done on excel but cannot figure out how to do it or what it is called.
Lets say:
A1 = 5
A2 = 3
to multiply these I would then type in =A1*A2
What I would like to do is have a cell explaining my formula...
A3 saying in text 5*3 and B3 next to is with the formula =A1*A2
I can do this by typing it in BUT if I change A1 or A2, I would need to physically retype A3.
How can I make it such that the text in A3 changes automatically according to the value of A1 and A2.
Many thanks
I have seen a useful trick done on excel but cannot figure out how to do it or what it is called.
Lets say:
A1 = 5
A2 = 3
to multiply these I would then type in =A1*A2
What I would like to do is have a cell explaining my formula...
A3 saying in text 5*3 and B3 next to is with the formula =A1*A2
I can do this by typing it in BUT if I change A1 or A2, I would need to physically retype A3.
How can I make it such that the text in A3 changes automatically according to the value of A1 and A2.
Many thanks