John R. Sowden wrote:
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. T
John R. Sowden wrote:
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. T
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
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
At 13:16 11/03/2007 -0800, 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.
=IF(I7="E";L6+F7-G7;L6+F7)
this is very interesting. The len() function produced a value of 0
when the cell wa
On Sun March 11 2007 12:43, Brian Barker wrote:
> At 12:18 11/03/2007 -0800, 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.
> >>=IF(I7="E";L6+F7-G7;L6+F7)
> >
> >The clean(I7) functio
At 12:18 11/03/2007 -0800, 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.
=IF(I7="E";L6+F7-G7;L6+F7)
The clean(I7) function had no effect. The left(trim(I7)) function
solved the proble
On Sun March 11 2007 11:25, Brian Barker wrote:
> At 09:46 11/03/2007 -0800, you 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 changing the format to general, number and text. No
>
> > =IF(I7="E";L6+F7-G7;L6+F7)
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.
Just replicated and formu
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
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
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"
12 matches
Mail list logo
