Return a High Number
 

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

Return a High Number
 

One way:

=MAX(A1:A5)

HTH,
Paul



--

"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

Return a High Number
 

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

Return a High Number
 

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

Tyro

"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

Return a High Number
 

One mo

=LARGE(A1:A10,1)


--
Biff
Microsoft Excel MVP


"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

Return a High Number
 

I always get a return of '0'

"Tyro" wrote:

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

Tyro

"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

Return a High Number
 

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

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

Anthony wrote:

I always get a return of '0'

"Tyro" wrote:

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

Tyro

"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




--

Dave Peterson