2007/10/8, mat1500 <[EMAIL PROTECTED]>: > > I am trying to put a formula in my spreadsheet that will put in a positive > number in a column if the sum of 3 columns is a positive number.
A random positive number or a special one? What wrong with this? =if(sum(a1:c1)>0;1;"") If not, it is very easy to create your own cell formulas with OpenOffice.orgBASIC, for example. If I use sumif it gives me any positive numbers in the three columns i am > totaling not the sum which may be a positive or negative number.QPRO uses > a formula that is easy to produce. Will openoffice convert formulas from > qpro or other spreadsheet programs? I don't know about QPRO, but it works with Excel spreadsheets anyway. Any help greatly appreciated. > > Ralph
