Remember Me?

#1
November 15th 04, 02:13 AM
 Yikes!! Posts: n/a
Calculation

I have designed a spreadsheet to calcualte wages at certain percentage
increases over 4 years. Rather than input the percentage into every
calculation, I would simply like to change one formula and have the rest
follow suit. Can I do this? I am sorry if this doesn;t make sense, but it
is the best description I can come up with. Thanks!

#2
November 15th 04, 02:41 AM
 JulieD Posts: n/a

Hi

choose a cell to put the % figure into (say J1) and then in the formula just
reference that cell, e.g.
=A1*\$J\$1
the \$ makes the reference absolute, so you can fill the reference down and
across and it will always refer to J1. Now, you just have to change the
value in J1 and all your formulas will recalculate.

Hope this is what you're after.

Cheers
JulieD

"Yikes!!" wrote in message
...
I have designed a spreadsheet to calcualte wages at certain percentage
increases over 4 years. Rather than input the percentage into every
calculation, I would simply like to change one formula and have the rest
follow suit. Can I do this? I am sorry if this doesn;t make sense, but
it
is the best description I can come up with. Thanks!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Joejoethecrackman Excel Discussion (Misc queries) 5 March 22nd 05 08:47 PM Sean Excel Discussion (Misc queries) 5 January 19th 05 02:33 PM Jeff K. Excel Discussion (Misc queries) 2 December 15th 04 01:39 AM Jim Excel Worksheet Functions 0 November 11th 04 09:42 PM dokliver Excel Worksheet Functions 3 October 28th 04 09:07 PM

All times are GMT +1. The time now is 10:28 PM.