The Function wizard is something that will be a key factor in my understanding of Functions. There also is the Help button that has a wealth of information.
You seem to be one of those very rare people who knows OpenOffice AND knows what and how to communicate with someone who is learning a part of OpenOffice. I color coded the formula you sent to understand the structure. The following are some of the pieces from you total formula. Each piece is on a separate line. IF ( OR (A1="" ; B1="") ; IF (A1=0 ; 1 ; "∞%") ) ) ) Walter On Mon, Jun 8, 2009 at 12:07 PM, Johnny Rosenberg <[email protected]>wrote: > 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 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
