Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest number
I have a range of cells with a number in each cell (below).
Cell C1 24 Cell C2 12 Cell C3 14 Cell C4 7 I want a formula that gets the largest number in Cell B1. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest number
Try the MAX function...
=MAX(C1:C4) -- Rick (MVP - Excel) "MAX" wrote in message ... I have a range of cells with a number in each cell (below). Cell C1 24 Cell C2 12 Cell C3 14 Cell C4 7 I want a formula that gets the largest number in Cell B1. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest number
In B1:
=MAX(C1:C4) -- Kind regards, Niek Otten Microsoft MVP - Excel "MAX" wrote in message ... I have a range of cells with a number in each cell (below). Cell C1 24 Cell C2 12 Cell C3 14 Cell C4 7 I want a formula that gets the largest number in Cell B1. Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest number
Use your name <s.
=MAX(C1:C4) HTH Kostis Vezerides On Apr 29, 7:09*pm, MAX wrote: I have a range of cells with a number in each cell (below). Cell C1 *24 Cell C2 *12 Cell C3 *14 Cell C4 *7 I want a formula that gets the largest number in Cell B1. Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest number
Hi,
=LARGE(c1:c4,1) 1 will give you the largest 2 will give you the 2nd largest and so on If this helped please click yes, thanks "MAX" wrote: I have a range of cells with a number in each cell (below). Cell C1 24 Cell C2 12 Cell C3 14 Cell C4 7 I want a formula that gets the largest number in Cell B1. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Largest Prime Number | Excel Discussion (Misc queries) | |||
Finding the largest number help | Excel Discussion (Misc queries) | |||
highlight largest number in a row | Excel Worksheet Functions | |||
finding the largest number from the last row and look up its name. | Excel Worksheet Functions | |||
How do I sum 4 number discarding the largest number. | Excel Worksheet Functions |