ExcelBanter - Largest number 2

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Largest number 2 (https://www.excelbanter.com/excel-worksheet-functions/229261-largest-number-2-a.html)

Max

Largest number 2

I have a range of cells with a number in each cell (below).
Cell C1 2
Cell C2 12
Cell C3 14
Cell C4 7

I want a formula that gets the largest number in Cell C1.

Thanks

Jacob Skaria

Largest number 2

=MAX(C1:C4)

If this post helps click Yes
---------------
Jacob Skaria

"MAX" wrote:

I have a range of cells with a number in each cell (below).
Cell C1 2
Cell C2 12
Cell C3 14
Cell C4 7

I want a formula that gets the largest number in Cell C1.

Thanks

Gary''s Student

Largest number 2

In C1 enter:
=MAX(C2:C4)
--
Gary''s Student - gsnu200850

"MAX" wrote:

I have a range of cells with a number in each cell (below).
Cell C1 2
Cell C2 12
Cell C3 14
Cell C4 7

I want a formula that gets the largest number in Cell C1.

Thanks

John[_22_]

Largest number 2

Hi Max
Type this =MAX(C2:C100) in C1, change range to your needs
HTH
John
"MAX" wrote in message
...
I have a range of cells with a number in each cell (below).
Cell C1 2
Cell C2 12
Cell C3 14
Cell C4 7

I want a formula that gets the largest number in Cell C1.

Thanks

All times are GMT +1. The time now is 03:16 AM.