[Duncan]

Hi

I have a table (3 rows). rows 1 and 2 contain a Text form field, both of
which are Type = Number.

I then have, in row 3, a calculated field. (Formula = A1/A2).
I need to show the result a a percentage to 4 decimal places.

I am completely stuck. (
Can anyone help please?

[macropod[_2_]]

Hi Duncan,

You can do this easily with a formula field instead of a formfield. Simply press Ctrl-F9 to create a pair of field braces (ie '{ }')
and type: '=A1/A2*100 \# 0.0000%' between the field braces, so that you end up with '{=A1/A2*100 \# 0.0000%}'. Then protect your
document. If A1 has 5 and A2 has 7, you'll get 71.4286% as the result.

--
Cheers
macropod
[MVP - Microsoft Word]


"Duncan" wrote in message ...
Hi

I have a table (3 rows). rows 1 and 2 contain a Text form field, both of
which are Type = Number.

I then have, in row 3, a calculated field. (Formula = A1/A2).
I need to show the result a a percentage to 4 decimal places.

I am completely stuck. (
Can anyone help please?

[Duncan]

Hi Macropod

That is great, thank you.........however (there is always a however isn't
there!!)

How do I get around deviding by zero? At present I get the following "!Zero
Divide"

"macropod" wrote:

Hi Duncan,

You can do this easily with a formula field instead of a formfield. Simply press Ctrl-F9 to create a pair of field braces (ie '{ }')
and type: '=A1/A2*100 \# 0.0000%' between the field braces, so that you end up with '{=A1/A2*100 \# 0.0000%}'. Then protect your
document. If A1 has 5 and A2 has 7, you'll get 71.4286% as the result.

--
Cheers
macropod
[MVP - Microsoft Word]


"Duncan" wrote in message ...
Hi

I have a table (3 rows). rows 1 and 2 contain a Text form field, both of
which are Type = Number.

I then have, in row 3, a calculated field. (Formula = A1/A2).
I need to show the result a a percentage to 4 decimal places.

I am completely stuck. (
Can anyone help please?

[Graham Mayor]

You can error trap the warning message with a conditional field eg

{IF {=A1/A2} "!Z*" "{=A1/A2*100 \# 0.0000%}" "0.0000%"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Duncan wrote:
Hi Macropod

That is great, thank you.........however (there is always a however
isn't there!!)

How do I get around deviding by zero? At present I get the following
"!Zero Divide"

"macropod" wrote:

Hi Duncan,

You can do this easily with a formula field instead of a formfield.
Simply press Ctrl-F9 to create a pair of field braces (ie '{ }') and
type: '=A1/A2*100 \# 0.0000%' between the field braces, so that you
end up with '{=A1/A2*100 \# 0.0000%}'. Then protect your document.
If A1 has 5 and A2 has 7, you'll get 71.4286% as the result.

--
Cheers
macropod
[MVP - Microsoft Word]


"Duncan" wrote in message
...
Hi

I have a table (3 rows). rows 1 and 2 contain a Text form field,
both of which are Type = Number.

I then have, in row 3, a calculated field. (Formula = A1/A2).
I need to show the result a a percentage to 4 decimal places.

I am completely stuck. (
Can anyone help please?

[macropod[_2_]]

Hi Duncan.

Basically, the same as you would in Excel:
{=IF(A2=0,0,A1/A2*100) \# 0.0000%}

--
Cheers
macropod
[MVP - Microsoft Word]


"Duncan" wrote in message ...
Hi Macropod

That is great, thank you.........however (there is always a however isn't
there!!)

How do I get around deviding by zero? At present I get the following "!Zero
Divide"

"macropod" wrote:

Hi Duncan,

You can do this easily with a formula field instead of a formfield. Simply press Ctrl-F9 to create a pair of field braces (ie
'{ }')
and type: '=A1/A2*100 \# 0.0000%' between the field braces, so that you end up with '{=A1/A2*100 \# 0.0000%}'. Then protect your
document. If A1 has 5 and A2 has 7, you'll get 71.4286% as the result.

--
Cheers
macropod
[MVP - Microsoft Word]


"Duncan" wrote in message ...
Hi

I have a table (3 rows). rows 1 and 2 contain a Text form field, both of
which are Type = Number.

I then have, in row 3, a calculated field. (Formula = A1/A2).
I need to show the result a a percentage to 4 decimal places.

I am completely stuck. (
Can anyone help please?