IF Formula HELP!!

[Swtmelly]

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

 

[macropod]

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

 

[Swtmelly]

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?

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]

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

 

[macropod]

Hi Swtmelly,

This approach most certainly does work in tables!

--
Cheers
macropod
[MVP - Microsoft Word]

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?

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]

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