[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[_2_]]

See reply in microsoft.public.word.tables

Please don't post the same question separately in multiple newsgroups.

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