2009/6/8 Walter Hildebrandt <[email protected]>: > 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.
Thanks…! Well, I can't really say that I know OpenOffice.org; I know some parts of it, that is those parts that I use regularly. I've asked many questions here throughout the years… :) Johnny Rosenberg > > 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] >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
