R Rodney Jan 22, 2009 #1 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?
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?
M Max Jan 22, 2009 #2 Rodney said: 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? Click to expand... 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 ---
Rodney said: 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? Click to expand... 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 ---
