Solved: Calculate an average

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Guest2

Thread Starter
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
 

Ent

Josiah
Retired Trusted Advisor
Joined
Apr 11, 2009
Messages
5,467
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,"")
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top