Return a High Number

[Anthony]

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

 

[PCLIVE]

One way:

=MAX(A1:A5)

HTH,
Paul

 

[Chip Pearson]

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)

 

[Tyro]

If your numbers are in A1:C10 then =MAX(A1:C10) returns the highest number
in the range.

Tyro

 

[T. Valko]

One more:

=LARGE(A1:A10,1)

 

[Anthony]

I always get a return of '0'

If your numbers are in A1:C10 then =MAX(A1:C10) returns the highest number
in the range.

Tyro

 

[Dave Peterson]

Try:
=count(a1:c10)
(change the range to match)

Maybe those things that look like numbers aren't really numbers.