What I'm trying to do is take a spreadsheet that is already setup with
various formulas and functions and use one cell to change the contents of the
others. For example if in that one cell I have a 5, then all the other cells
should represent the result of the function or formula multiplied by 5. Or if
I entered a 3 everything should be multiplied by 3.

Is this possible?

Yes, and quite easily:-

Assuming your data is in say C5:Z100

In say cell A1 put 3
In say cell A2 put =$A$1
Copy cell A2
Select all your data in C5:Z100 and do edit / Paste Special / Check
'Formulas' in the Paste Section and 'Multiply' in the Operation section
Hit OK and then delete cell A2.

Your cells are now all linked to cell A1, regardless of whether they had
held values or formulas, and if you change A1 you change everything.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Lady Lioness" <Lady wrote in message
...
What I'm trying to do is take a spreadsheet that is already setup with
various formulas and functions and use one cell to change the contents of
the
others. For example if in that one cell I have a 5, then all the other
cells
should represent the result of the function or formula multiplied by 5. Or
if
I entered a 3 everything should be multiplied by 3.

Is this possible?

Easiest method (to me) is to put the value in a cell. Name that cell, such
as "intrate" for interest rate. In your formulas, just type =A3*intrate
*******************
~Anne Troy

www.OfficeArticles.com


"Lady Lioness" <Lady wrote in message
...
What I'm trying to do is take a spreadsheet that is already setup with
various formulas and functions and use one cell to change the contents of
the
others. For example if in that one cell I have a 5, then all the other
cells
should represent the result of the function or formula multiplied by 5. Or
if
I entered a 3 everything should be multiplied by 3.

Is this possible?