(Msg. 2) Posted: Thu Oct 02, 2008 3:05 am
Post subject: Re: IF Formula HELP!! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
Try coding your formula field as:
{=IF(B24=0,0,B23/B24) \# "0.00"}
"Swtmelly" <Swtmelly.DeleteThis@discussions.microsoft.com> wrote in message news:400F41E4-94A2-43A4-AEBD-043096EE1374@microsoft.com...
>I need a !ZERO Divide error to show as 0.00 if the divisor is 0.00.
>
> I worked out the formula in EXCEL, but I can't work it out in WORD. Please
> help.
>
> =IF(B23/B24=0,"0.00",B23/B24)
>
> This gives me syntax error in word.
>
> Melanie
(Msg. 3) Posted: Thu Oct 02, 2008 12:26 pm
Post subject: Re: IF Formula HELP!! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I can't get it to work, I've heard about ctrl F9 to get the brackets -
doesn't work in table/formula. What am I doing wrong?
"macropod" wrote:
> Hi,
>
> Try coding your formula field as:
> {=IF(B24=0,0,B23/B24) \# "0.00"}
>
> For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at:
> http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442 > or
> http://www.gmayor.com/downloads.htm#Third_party >
>
> --
> Cheers
> macropod
> [MVP - Microsoft Word]
>
>
> "Swtmelly" <Swtmelly RemoveThis @discussions.microsoft.com> wrote in message news:400F41E4-94A2-43A4-AEBD-043096EE1374@microsoft.com...
> >I need a !ZERO Divide error to show as 0.00 if the divisor is 0.00.
> >
> > I worked out the formula in EXCEL, but I can't work it out in WORD. Please
> > help.
> >
> > =IF(B23/B24=0,"0.00",B23/B24)
> >
> > This gives me syntax error in word.
> >
> > Melanie
>
(Msg. 4) Posted: Fri Oct 03, 2008 3:05 am
Post subject: Re: IF Formula HELP!! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Swtmelly,
This approach most certainly does work in tables!
--
Cheers
macropod
[MVP - Microsoft Word]
"Swtmelly" <Swtmelly.DeleteThis@discussions.microsoft.com> wrote in message news:2F3AF2F4-D803-44BB-871E-87EDCB4F1630@microsoft.com...
>I can't get it to work, I've heard about ctrl F9 to get the brackets -
> doesn't work in table/formula. What am I doing wrong?
>
> "macropod" wrote:
>
>> Hi,
>>
>> Try coding your formula field as:
>> {=IF(B24=0,0,B23/B24) \# "0.00"}
>>
>> For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at:
>> http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442 >> or
>> http://www.gmayor.com/downloads.htm#Third_party >>
>>
>> --
>> Cheers
>> macropod
>> [MVP - Microsoft Word]
>>
>>
>> "Swtmelly" <Swtmelly.DeleteThis@discussions.microsoft.com> wrote in message news:400F41E4-94A2-43A4-AEBD-043096EE1374@microsoft.com...
>> >I need a !ZERO Divide error to show as 0.00 if the divisor is 0.00.
>> >
>> > I worked out the formula in EXCEL, but I can't work it out in WORD. Please
>> > help.
>> >
>> > =IF(B23/B24=0,"0.00",B23/B24)
>> >
>> > This gives me syntax error in word.
>> >
>> > Melanie
>>
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