Status
Not open for further replies.
1 - 3 of 3 Posts

#### Guest2

·
##### Registered
Joined
·
12 Posts
Discussion Starter · ·
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

#### Ent

·
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,"")``

#### Guest2

·
##### Registered
Joined
·
12 Posts
Discussion Starter · ·
That works for our needs - thanks for your time

1 - 3 of 3 Posts
Status
Not open for further replies.