Thread: How do I display a minimum or cell value?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How do I display a minimum or cell value?
=MAX(35,SUM(A1:A15))
--
David Biddulph

"Rodney" wrote in message
...
How can I display either a cell value made from sum of other cells or, if
that value is under 35 display the minimum of 35?
--
Rodney


Reply With QuoteReply With Quote