!Zero Divide

[P Ward - YMCA]

In Word, I'm trying to divide two (2) text fields and have the result
returned to another field. The formula I'm using looks like this
=Text17/Text18 \# "0.00" .
I want the field to return the correct answer but until someone enters data
the division is 0/0 and I get !Zero Divide. This calculation is not in a
table. Is if possible to have the formula field read 0 until data in enter in
the text fields and then updated? Thanks in advance.

 

[Dave Lett]

Hi,

You might try the following:

{ IF { = { REF Text17 }/{ REF Text18 } } = "!Zero Divide" "0" { = { REF
Text17 }/{ REF Text18 } } }

HTH,
Dave

 

[Jonathan West]

In Word, I'm trying to divide two (2) text fields and have the result
returned to another field. The formula I'm using looks like this
=Text17/Text18 \# "0.00" .
I want the field to return the correct answer but until someone enters
data
the division is 0/0 and I get !Zero Divide. This calculation is not in a
table. Is if possible to have the formula field read 0 until data in enter
in
the text fields and then updated? Thanks in advance.

Put the field inside an IF field, and have the IF field display 0 if the
field inside returns "!Zero Divide"


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Tony Jollans]

Personally I'd check for Text18 being zero rather than the actual error
text.

=if(text18=0,0,text17/text18) \# 0.00