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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
