2009/6/8 Walter Hildebrandt <[email protected]>: > Johnny, ignore my previous Reply to this Email. Your formula is working as > it should.
I'm glad to hear that. By the way, you know that you can hit Ctrl+F2 to input formulas in a somewhat more guided way, don't you? If not, try! It makes life somewhat easier. You can place the cursor in different places in the formula and see the value of the whole formula as well as a part of the formula at the same time. This makes debugging somewhat easier. And you know that you can make your own cell functions too? You can make them in OpenOffice.org BASIC and make them available in all your spreadsheets or just a specific one, you decide. Johnny Rosenberg > > 2009/6/7 Walter Hildebrandt <[email protected]> > >> Johnny, I tested all the different possibilities and found, assuming I did >> not make a mistake, there was one condition that did not work properly. >> When A1 was empty and there was a negative number in B1, C1 had Empty. C1 >> should be Empty,Negative. >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
