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