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, -- 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]
