Word 2007 - cell not in table

[formerTexan]

I inserted a new 5 column (presumably columns A,B,C,D,E) table into a Word 2007 docx.

I entered a formula in the table referencing B1. No problem.
Then entered the same formula in another cell of the same table and changed the reference to cell E1. I get a "E1 is not in table" response.

For grins went and duplicated the above in Word 2000 and everything worked fine.

Microsoft claim that cells are designated logically. Any ideas as to whats up with the cell referencing?

Cheers,
Bill

 

[SkipVought]

what formula in what cell?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[formerTexan]

Formula: {IF{B3}<500 "not available" {=((((B3*E1)/100)+B3)/6)+50}}

Initially placed in what I presumed was cell E5. However which cell seems irrelevant. Same results when placed in other cells.

Cheers

 

[SkipVought]

this worked for me with 600 in B3
[tt]
=IF(B3<500,0,((((B3*E1)/100)+B3)/6)+50)
[/tt]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[macropod]

Either of the following work for me in a 5-column table:
{IF B3 < 500 "not available" {=(B3*E1/100+B3)/6+50}}
{IF(=B3}< 500 "not available" {=(B3*E1/100+B3)/6+50}}

Cheers
Paul Edstein
[MS MVP - Word]