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

[Morrigan]

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.

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

[bhofsetz]

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.

[slr]

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]

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.

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?

[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