Urgent - Formula for incr/decrease of 5 cells
 

I need this by 30 minutes if possible.

I have 5 membership totals. I need to know the formula or function to
plug in to show me the max or min of the 5 cells.

What I want to say: Did my memberships increase or decrease over the
past 5 yrs.??? and, by how much??

Thank you for your quick repsone.
SLR


--
slr
------------------------------------------------------------------------
slr's Profile: http://www.excelforum.com/member.php...o&userid=25609
View this thread: http://www.excelforum.com/showthread...hreadid=390360

To find out the max or min is simply

=MAX(range of cells)
=MIN(range of cells)

I am not understanding what you want when you say "Did my memberships
increase or decrease over the past 5 yrs". To me, that is just a
comparison. I am not sure what you actually want to know.



slr Wrote:
I need this by 30 minutes if possible.

I have 5 membership totals. I need to know the formula or function to
plug in to show me the max or min of the 5 cells.

What I want to say: Did my memberships increase or decrease over the
past 5 yrs.??? and, by how much??

Thank you for your quick repsone.
SLR


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390360

Why don't you just use the Max and Min functions?

= MAX(A1:A5)

= MIN(A1:A5)

replace the A1:A5 with your actual range.


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=390360

Thanks.

Do I put the formula for MAx and MIN in the same cell, because I need
to know if I increased or decreased over the 5 yrs.

How would I join the two to make a positive or negative number come
out?


--
slr
------------------------------------------------------------------------
slr's Profile: http://www.excelforum.com/member.php...o&userid=25609
View this thread: http://www.excelforum.com/showthread...hreadid=390360

The 2 formulas will be in 2 different cells. MAX() and MIN() will give
you the maximum and minimum value out of the selected range of cells.
They do NOT tell you did membership increase or decrease.


slr Wrote:
Thanks.

Do I put the formula for MAx and MIN in the same cell, because I need
to know if I increased or decreased over the 5 yrs.

How would I join the two to make a positive or negative number come
out?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390360

A little more information may be helpful.

What is in each of your 5 cells that you want to find the max and min
for?

If you have

A ..........B
year 1...22
year 2...35
year 3...18
year 4...28
year 5...26

Then
=MAX(B2:B6) would return 35
=MIN(B2:B6) would return 18

Your overall memebership increased by 4 for the 5 year period and you
can get that simply with

=B6-B2

If you want the greatest difference in membership use

=MAX(B2:B6)-MIN(B2:B6)

If you want the difference between the current membership and the
highest membership then use

=B6-MAX(B2:B6)

Likewise the difference between the current and minimmum then use

=B6-MIN(B2:B6)

Hope This Helps


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=390360