| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to throw out high number and low number | Excel Worksheet Functions | |||
| How to format number and not return ###### | Excel Worksheet Functions | |||
| Return a value when the number is negative | Excel Worksheet Functions | |||
| change the color of a number when it gets too high | Excel Discussion (Misc queries) | |||
| how to return a certain value if a number is within a range | Excel Discussion (Misc queries) | |||
Linear Mode
