On Thursday 30 June 2005 04:04, Gert Blij wrote: > How can I create an IF statement that says: > > If a cell is blank (null (?)) do something else do something else. > > TIA > Gert > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] I went through this a few years ago. On a ledger sheet with: DATE, DOC#, ITEM,DEBIT,CREDIT,BALANCE I did not want the balance showing down the screen to the "bottom" of the spreadsheet. You cannot test the same cell with the formula. What I did was test the ITEM column to decide whether to show the balance: =if(c10="";"";f9+d10-e10) is what I used to bring the balance forward.
Hope that helps. -- 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]
