ExcelBanter - find the largest value in column, put in a cell

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - find the largest value in column, put in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/76792-find-largest-value-column-put-cell.html)

find the largest value in column, put in a cell

If value in cell a1 = 1 through 149, display "0" in a2
If vallue in cell a1 = 150 or greater, display actual value of a1, in cell a2

find the largest value in column, put in a cell

JcR wrote:
If value in cell a1 = 1 through 149, display "0" in a2
If vallue in cell a1 = 150 or greater, display actual value of a1, in
cell a2
In A2:
=IF(A1<150,0,A1)

find the largest value in column, put in a cell

JcR Wrote:
If value in cell a1 = 1 through 149, display "0" in a2
If vallue in cell a1 = 150 or greater, display actual value of a1, in
cell a2
Whoops!!,
Might have the wrong question here,
I will answer your Title question,

=MAX(A2:A8)

this will give you the max number in the range A2:A8

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521558