The MAX function will return the largest value of a range. E.g.,
=MAX(A1:A10)
--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
"Anthony" wrote in message
...
Is there a formula if in diffrent cells I have a number and I want it to
return the highest number is that area. If anyone could please help.
Thanks