(Msg. 2) Posted: Thu Oct 02, 2008 10:31 pm
Post subject: Re: Formatting a Text Form Field [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Duncan DeleteThis @discussions.microsoft.com> wrote in message news:925F8139-C420-448C-85D1-8EB074DB2BA6@microsoft.com...
> 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?
(Msg. 3) Posted: Thu Oct 02, 2008 10:31 pm
Post subject: Re: Formatting a Text Form Field [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Duncan RemoveThis @discussions.microsoft.com> wrote in message news:925F8139-C420-448C-85D1-8EB074DB2BA6@microsoft.com...
> > 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?
>
>
(Msg. 4) Posted: Thu Oct 02, 2008 10:31 pm
Post subject: Re: Formatting a Text Form Field [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You can error trap the warning message with a conditional field eg
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" <Duncan.DeleteThis@discussions.microsoft.com> wrote in message
>> news:925F8139-C420-448C-85D1-8EB074DB2BA6@microsoft.com...
>>> 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?
(Msg. 5) Posted: Fri Oct 03, 2008 3:05 am
Post subject: Re: Formatting a Text Form Field [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Duncan.RemoveThis@discussions.microsoft.com> wrote in message news:5E5B1441-CB38-4001-885A-24682F129719@microsoft.com...
> 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" <Duncan.RemoveThis@discussions.microsoft.com> wrote in message news:925F8139-C420-448C-85D1-8EB074DB2BA6@microsoft.com...
>> > 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?
>>
>>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
(
Office