The following formula stopped working when I started a new sheet for 2007. The part that is not working is the test of the cell I7. I have tried changign teh format to general, number and text. No change. The only way I can get the formula to work is if I put a reference in I7, such as "=A1" to another cell with the "E" in it. This formula is used in a cash flow analysis sheet.
=IF(I7="E";L6+F7-G7;L6+F7) tia, -- 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]
