#1   Report Post  
Old November 15th 04, 02:13 AM
Yikes!!
 
Posts: n/a
Default 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   Report Post  
Old November 15th 04, 02:41 AM
JulieD
 
Posts: n/a
Default

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!





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I use a check box to accept a calculation Joejoethecrackman Excel Discussion (Misc queries) 5 March 22nd 05 08:47 PM
About Calculation of Excel Sean Excel Discussion (Misc queries) 5 January 19th 05 02:33 PM
Auto Calculation Automatically Turns Off???? Jeff K. Excel Discussion (Misc queries) 2 December 15th 04 01:39 AM
Help on automatically ending a calculation Jim Excel Worksheet Functions 0 November 11th 04 09:42 PM
time-clock calculation dokliver Excel Worksheet Functions 3 October 28th 04 09:07 PM


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017