A A|ex Registered User. Local time Today, 10:22 Joined Jul 11, 2004 Messages 90 Jul 25, 2004 #1 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.
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.
A A|ex Registered User. Local time Today, 10:22 Joined Jul 11, 2004 Messages 90 Jul 25, 2004 #3 doesnt work still displaying same error :/
A A|ex Registered User. Local time Today, 10:22 Joined Jul 11, 2004 Messages 90 Jul 25, 2004 #4 =IIf([priceBoxDifference1]=0,"0%",[priceBoxDifference1]/[NettValue]) Figured it out so it now displays 0%
=IIf([priceBoxDifference1]=0,"0%",[priceBoxDifference1]/[NettValue]) Figured it out so it now displays 0%
