Hide #Div/0! ???

[A|ex]

Is there a way to hide #Div/0! error when no data has been entered for the calc to work out? i rather just have nothing appear and then a figure when numbers are entered.

 

[Rich]

=Iif (IsNull([Field1]),0,[Field1]/[Field2])

 

[A|ex]

doesnt work still displaying same error :/

 

[A|ex]

=IIf([priceBoxDifference1]=0,"0%",[priceBoxDifference1]/[NettValue])

Figured it out so it now displays 0%

 

[Pat Hartman]

Set the format to percent, don't put a string in a numeric field:

=IIf([priceBoxDifference1]=0, 0,[priceBoxDifference1]/[NettValue])