Need formula for 5 yr high/low

[slr]

Greetings,

Problem:

Need to calculate membership totals in columns "C thru G" to find ou
the growth or decline of membership in the last 5 yrs.
1848 1717 1702 1472 1369

I want the outcome to show up as a positive or negative number i
column "I"
(My column "H" is an AVG formula cell.)

Can someone send me something I can paste in myself?

I need this today!

Blessings,
SLR
:

 

[MrShorty]

Does the forumula c1-g1 do what you want? Basically it just calculate
the total change in membership. A negative result indicates
decrease, a positive result indicates an increase

 

[slr]

Thanks for your quick respone Mr. Shorty.

The totals in cells c1 thru g1 are just membership totals (numbers) fo
each yr.

What I need to do is create an "H1" cell that tells me if we increase
or decreased in membership from the first yr to the last yr. and
maybe in the same cell, by how much.

Is this something simple that you can help me with?

Can you design something so that I can zap it in?
SL

 

[MrShorty]

Can you not simply take the difference of the 1st and last years
numbers as I suggested?

PS I note that I got the order of the subtraction wrong for what I wa
intending. Should G1-C1 (lastyear-firstyear)

 

[slr]

Basically, the example below will show you what I have:

c1 d1 e1 f1 g1

1,848 1,717 1,702 1,472 1,369


I want to create a result in "I1" to tell me if the membership for
yrs. is a increase or decline. I guess you would compute each yr. t
the 1st until you end up with an overall increase or decrease --I don'
really know.

I just want a formula in "I1" to say memberships increased or decrease
over the past 5 yrs, and by how much.

Blessings,
SL

 

[MrShorty]

You've given two "goals" for your formula. I'm not sure what it i
about the formula =g1-c1 that isn't good enough. Your goals and ho
this formula acheives those goals:

1) Is membership for last year an increase or decrease from 1st year
membership? Indicated by the sign of the result. A negative resul
indicates a decrease in membership and a positive result indicates a
increase in membership.

2) How much of an increase or decrease? The value returned indicate
how many more or fewer members.

Are there more requirements that I'm missing

 

[slr]

Sorry, I am not making this easier for you. I am very visual vs
analytical.

2000 2001 2002 2003 2004
Increase/Decrease
*1,848 1,717 1,702 1,472 1,369*
Cell "H1" = ?


The figures you see above are the actual membership totals for each yr
in c1 thru g1 cells.

Perhaps by looking at the figures from left to right might indicate t
you what formula is needed. (As you can see, the yr. 2000 was our bes
yr.)

In summary, I want to show an increase or decrease and by how much i
the increase or decrease for all five yrs.'s total--that would go i
"H1."

Thanks Again,
SLR

I need this today if possible for a last minute project

 

[MrShorty]

I can see that 2000 was the best year, and that membership has bee
declining each year since. I can see that the smallest decrease cam
between 2001 and 2002 (-15), and that the largest decrease came betwee
2002 and 2003 (-230). Overall, membership has declined by a total o
-479 since 2000. But I'm just not sure which years you want to compar
(obviously not the first and the last).

Fill in the blanks: I want the formula in H1 to take the membershi
number from year _____(blank1) and compare it to year _____(blank2).

If it's pertinent, how did you determine which years to compare