Converting #error to 0

[Sed]

Anybody knows how to convert an # error formula to return "0"

Here's my formula: CWT: ([LineHaul]/[Cost/Lbs])/100

#error because it's dividing by 0, but I can't convert it to return zero

please help

 

[boblarson]

CWT: IIf([Cost/Lbs]=0,0,([LineHaul]/[Cost/Lbs])/100)

 

[Sed]

You are the MAN!!!! thank you Boblarson!!!