How do I display a minimum or cell value?
 

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

How do I display a minimum or cell value?
 

"Rodney" wrote:
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?

Try something like this,
in say B1: =MAX(35,SUM(A1:A10))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

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