Tech Support Guy banner
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,524 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