On Fri March 24 2006 10:21, John R. Sowden wrote: > Two application questions using OOo 2.0.0, under Suse 9.3 > > 1) I want to reference a sheet name based on the value of a cell: > a1="Sheet_Name" > formula: =_____(a1).c2 > ___ is the "missing function. > > 2) I have a ledger sheet with a balance column. I test to see if the > 'item' column is blank so I don't run the balance all the way town to row > 500, or whatever. If the item is blank, I make the balance cell blank. > > Problem: I want to put the last balance at the top of the page. How do I > reference the last cell to have data, which is the ending balance? > > Balance Column formula: =if(c5="";"";f4-d5+e5) > c5=item, d is debit, e is credit f is the balance column > > Thanks, Thanks to all, the response solved my problems. Adding the debits and credits is a good example of looking at a problem from a different point of view. Thanks again!
John -- John R. Sowden AMERICAN SENTRY SYSTEMS, INC. Residential & Commercial Alarm Service UL Listed Central Station Serving the San Francisco Bay Area Since 1967 [EMAIL PROTECTED] www.americansentry.net --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
