# Solved: Calculate an average

Discussion in 'Business Applications' started by Guest2, Apr 15, 2010.

Not open for further replies.

Joined:
Feb 5, 2010
Messages:
12
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

Joined:
Apr 11, 2009
Messages:
5,467
First Name:
Josiah
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,"")`

Joined:
Feb 5, 2010
Messages:
12
That works for our needs - thanks for your time

As Seen On