# Thread: Formulae (2000 SP-3)

1. ## Formulae (2000 SP-3)

I have constructed a Word table in which are some formulae. One formula is a very simple d36-e22-d13+d11, however when the other fields are completed and I press Ctl A, F9, the result is incorrect and has a bracket at either end. If I press F9 again the brackets disappear and the result is correct. It is as if the brackets are saying that the calculation is not complete? Can anyone shed some light please?

Regards, John Hunting
Forres, Scotland

2. ## Re: Formulae (2000 SP-3)

It would be helpful if you could post a document demonstrating the problem. Remove all sensitive data.

3. ## Re: Formulae (2000 SP-3)

Hans, example file attached. Use existing data. Press Ctl A, F9 and observe the field alongside 'Actual Contribution If Won, Including Contingency:'. Hopefully it will show an incorrect result in brackets until you press F9 again.

John Hunting
Forres, Scotland

4. ## Re: Formulae (2000 SP-3)

The problem is that D36 refers to a value in another table.
When you do the first update, D36 is still 0. All calculations in the first table are updated, resulting in D35 = 0-352-50 +0 = -402. The last table is updated, resulting in Total = 980, and this is propagated to D36 when D35 has already been recalculated.
In the next update, D36 is 980, so D35 = 980-352-50+0 = 578.
I don't know a workaround, except migrating the entire form to Excel.

5. ## Re: Formulae (2000 SP-3)

Still none the wiser as to why the result is in brackets - nothing documented in Word that I can find.

Regards, John Hunting
Forres, Scotland

6. ## Re: Formulae (2000 SP-3)

It's probably your system setting for negative numbers - you can check this in the Regional Settings control panel. On my system, the intermediate result was displayed as -402, but if your system is set to enclose negative numbers in parentheses, you see (402)

7. ## Re: Formulae (2000 SP-3)

I couldn't see anything in brackets. First update gave -402, second gave 578.
I'm wondering if it's to do with your Regional Settings (Control Panel). There's an option to display negative numbers in the format (402).

Alan

8. ## Re: Formulae (2000 SP-3)

Sometimes I don't know why I bother! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Alan

9. ## Re: Formulae (2000 SP-3)

Hi John,

The simple solution to your problem is to change the formula at B35 to:
{=total-e22-d13+d11}

As for the result in brackets, that's simply the formatting defined by your system for negative results. You can control the numeric formatting via field picture switches. See the Word Help file, or my <post#=365442>post 365442</post#> for a more in-depth discussion.

Cheers

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•