IF Formula in WORD

S

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
 
M

macropod

See reply in microsoft.public.word.tables

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro on different reports CTRL+F in formula 2
I am trying to use the IF and SUMIF function on Excel 8
Using a IF AND statement in Word Fields 8
formula field: don't display anything when value is zero (using ;" 5
Clever formula required (to find the word directly preceding mychosen word) 3
if command with tiers 2
How to get rid of #Value! 6
EXCEL 2003*FORMULA TO HILIGHT SPECIFIC CELLS WITH TRUE RESULTS? 6

Top