Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
12 Posts
Discussion Starter · #1 ·
In excel I would like to calculate the value of Column A ($) / Column B(# of years) across the row, one result per column for each number of years.

Any suggestions would be greatly appreciated

Example:


7 $2,800 $400 $400 $400 $400 $400 $400 $400
5 $364 $73 $73 $73 $73 $73
3 $150 $50 $50 $50
2 $200 $100 $100
3 $250 $83 $83 $83
2 $210 $105 $105
2 $210 $105 $105
2 $200 $100 $100
2 $100 $50 $50
1 $140 $140
 

·
Retired Trusted Advisor
Joined
·
5,465 Posts
The ideal way would probably be to use macros. However if you put this in every box that may hold the results (i.e. every box with a 400 in your first example, for the maximum number of columns you'll have years) it should work

Code:
=IF(COLUMN()-2<=A1,B1/A1,"")
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top