# Thread: Return percentage in word table

1. ## 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. 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

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

jrb (2012-04-19)

4. 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. 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. 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.

7. 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. Hi jrb,

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

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

jrb (2012-04-21)

10. 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
•