On Sun March 11 2007 19:34, TerryJ wrote: > John R. Sowden wrote: > > 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 > > Does the formula still work in another location or on another sheet or in > another file? I've had to replace my test file because it was returning > manifestly incorrect results to formulas. I think the file was damaged > during the so-called crash "recovery" process, which I no longer use. The > last version has no "Statistics" tab in the File >Properties dialogue - > just to demonstrate that damaged files can appear to be functional at least > some of the time.
Different location-same sheet: Formula works Different Sheet-same file: Formula works Different file: not performed based on above Same sheet-point to a different test cell: formula works Seems to be pointing to format of the test cells in their collumn Hope this 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]