View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default How do I set a price minimum in a spreadsheet?

=MIN(A1:A100)

will return the minimum value in the range A1 to A100

--
Cheers
Nigel



"phahn" wrote in message
...