Urgent - Formula for incr/decrease of 5 cells

[slr]

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]

Thanks.

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

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

 

[Morrigan]

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

 

[bhofsetz]

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