LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
gvm
 
Posts: n/a
Default can't figure it

I want to set a default annual growth rate for each of 40 years and then let
a user specify a different growth rate for up to 4 particular years within
those 40, ie the user will change the default setting. I want the user input
area to be a simple 4 x 2 table where the first column is the year number,
the second column the amended growth rate. A list of growth rates for each of
the 40 years will reside in the calculation zone of the model.

I imagine the formula for growth rate for each of the 40 rows will check if
the year number matches a year number in the 4 x 2 table; if there is not a
match then the value is set to the default growth rate number, if there is a
match then the value is set to the corresponding value in the 4 x 2 table.
Sounds easy enough but I can't figure it. Any suggestions please?
 
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
minimum a fixed figure when it is lower weepel New Users to Excel 5 June 22nd 05 06:46 PM
Excel will not allow me to change a numerical figure in a specifi. [email protected] Excel Discussion (Misc queries) 2 April 15th 05 03:20 PM
How can I make a timesheet to figure my hours and payrate? Bruce Excel Worksheet Functions 2 March 25th 05 01:10 AM
how to type a minues figure jenniss New Users to Excel 1 February 8th 05 03:05 PM
excel to figure miles per gallon Terri New Users to Excel 5 January 9th 05 06:59 PM


All times are GMT +1. The time now is 09:16 PM.

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

About Us

"It's about Microsoft Excel"