Thread: find the largest value in column, put in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default 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)


Reply With QuoteReply With Quote