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. -- View this message in context: http://www.nabble.com/formula-stopped-working-refers-to-other-cells-tf3385246.html#a9428034 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
