Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Location
    Forres, Moray, Scotland
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formulae (2000 SP-3)

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

  3. #3
    New Lounger
    Join Date
    Dec 2001
    Location
    Forres, Moray, Scotland
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #5
    New Lounger
    Join Date
    Dec 2001
    Location
    Forres, Moray, Scotland
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulae (2000 SP-3)

    Thanks Hans, appreciate your rapid reply.
    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. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #9
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    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
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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