View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default 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/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party


--
Cheers
macropod
[MVP - Microsoft Word]


"Swtmelly" wrote in message ...
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