IF Formula HELP!!   

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

date: Wed, 1 Oct 2008 09:02:01 -0700   author:   Swtmelly

Re: IF Formula HELP!!   

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"  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

date: Thu, 2 Oct 2008 06:06:43 +1000   author:   macropod lid

Re: IF Formula HELP!!   

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"  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
>

date: Thu, 2 Oct 2008 12:26:08 -0700   author:   Swtmelly

Re: IF Formula HELP!!   

Hi Swtmelly,

This approach most certainly does work in tables!

-- 
Cheers
macropod
[MVP - Microsoft Word]


"Swtmelly"  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"  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
>>

date: Fri, 3 Oct 2008 07:01:42 +1000   author:   macropod lid