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