Hi,

One way.

Put 0.05 in a cell and give the cell a name (e.g. Factor)

then in any other cell you can enter =16*factor and get the answer you require
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"barkingmad" wrote:

Ms Office Excel 2003 ( Ms Office Professional Edition 2003)

I want to 'embed' a formula (eg: *.05) in multiple cells so that when data
is then entered into the cells it operates on the data and displays the
result. For instance, in the example given, if I then entered '16' into a
cell the figure displayed would be '0.8'