Inserting values from a cell into another text field/cell

[themerrymonk]

Hi,

I am raising this question for someone who has no internet (yes there are still some )

Is it possible to take a value from one cell (lets say a value of 20) and insert that cell's value into another cell already containing some text?

As an example, lets say a cell was set for "number of iterations" (i.e the 20 mentioned previously) and another cell reported the result of some calculation based on this number, with a cell next to that that had some text saying "this is the result of 20 iterations" - where the 20 is obtained from the other cell?

As you can probably guess, the number of iterations can be changed by a user of the worksheet, and therefore the text/label cell needs to reflect this possible change as well

Thanks in advance for any assistance :D

Tmm

 

[Aladin Akyurek]

="this is the result of "& A1&" iterations"

where A1 houses a number indicating the actual number of iterations.

 

[themerrymonk]

Sir, you are a genius :D :D :D

Many Thanks,

Tmm