Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Aug 2011
    Posts
    112
    Thanks
    35
    Thanked 3 Times in 3 Posts

    Return percentage in word table

    I have a table which shows the difference between two inputs.

    E4 >> 8
    B4 >> 10
    {=E4-B4} >> returns -2

    In another cell I want to return the percentage decrease which is -20%

    I've used {100*E4/B4 \# "0.00%"} and this returns 80.00% when I would expect -20.00%.

    What have I missed here?

    A follow-up question? In the end I would like the -2 and the percentage in one cell.

    Example:
    -2 (-20.00%)

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,853
    Thanks
    4
    Thanked 259 Times in 239 Posts
    E4/B4 is 8/10 or 80%

    If you want to see the change as a percentage your equation needs to be 100*(E4-B4)/B4

    To get both answers in the same cell, just use a second field
    Last edited by Andrew Lockton; 2012-04-19 at 19:57.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    jrb (2012-04-19)

  4. #3
    2 Star Lounger
    Join Date
    Aug 2011
    Posts
    112
    Thanks
    35
    Thanked 3 Times in 3 Posts
    Thank you very much Andrew. I'm not 100% following "using a second field".

    To enter the initial formula >> Layout >> Formula

    Are you now saying to go to >> Insert >> Quick parts >> Field?

    I've tried that but in the cell is the formula I started with and trying to put another one in it just replaces the original.

  5. #4
    2 Star Lounger
    Join Date
    Aug 2011
    Posts
    112
    Thanks
    35
    Thanked 3 Times in 3 Posts
    Hi again Andrew,

    I don't know what I did but I finally got it to work using the Insert >> Quick parts

    Thank you so much for your time

  6. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    The simplest approach would be to use two formula fields, coded like: {=E4-B4 \# 0.00} {=(E4-B4)*10 \# 0.00%}

    Note: The field brace pairs (ie '{ }') for the above example are created in the table itself via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  7. #6
    2 Star Lounger
    Join Date
    Aug 2011
    Posts
    112
    Thanks
    35
    Thanked 3 Times in 3 Posts
    Thank you Paul. I just ran across another issue.

    I need to roundup the delta so I use =INT(SUM(B4)+SUM(C4)+IF(MOD(SUM(B4)+SUM(C4),1)>0,1 ,0))

    If the delta should happen to be example -10.8, this formula will return -10, when I would expect -11.

  8. #7
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi jrb,

    If you're trying to roundup negative numbers, you should be able to use nothing more complicated than {=INT(SUM(B4) \# 0}
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  9. The Following User Says Thank You to macropod For This Useful Post:

    jrb (2012-04-21)

  10. #8
    2 Star Lounger
    Join Date
    Aug 2011
    Posts
    112
    Thanks
    35
    Thanked 3 Times in 3 Posts
    Perfect, thanks

Posting Permissions

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