On Sun March 11 2007 10:08, Dan Lewis wrote: > On Sunday March 11 2007 12:46 pm, 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, > > I place an E in cell I7 (no quotes around the E) and values in F7 > (31), G7 (121), and L6 (27). In A1, I entered this formula: > =IF(I7="E";L6+F7-G7;L6+F7). I got two different answers depending > upon whether cell I7 contained a capital e or not. (-63 if I7=E, and > 58 for no value or any other value in I7.) > Where did you place the formula you mentioned? Did you enter > a "E" with the quotes in I7? > > Dan > --------------------------------------------------------------------- The formula is in cell L7, and down the page. There are no quotes arround the E. This same formula has worked fine for the last 13 years, going back to Quattro Pro/DOS days. I believe the issue is the format of the cell holding the E.
-- 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]
